Groups
Sign in
Groups
pgsql.performance
Conversations
About
Send feedback
Help
info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Learn more
pgsql.performance
Contact owners and managers
1–30 of 4985
Mark all as read
Report group
0 selected
Tatsuo Ishii
, …
Kamlesh Kumar
3
1/21/23
Re: [PERFORM] PgPool II configuration with PostgreSQL 8.4
On Friday, May 7, 2010 at 3:28:10 AM UTC+5, Rosser Schwarz wrote: > On Wed, May 5, 2010 at 10:17
unread,
Re: [PERFORM] PgPool II configuration with PostgreSQL 8.4
On Friday, May 7, 2010 at 3:28:10 AM UTC+5, Rosser Schwarz wrote: > On Wed, May 5, 2010 at 10:17
1/21/23
kill...@coronavirus.com
4/18/20
coronavirus COVID-19
coronavirus COVID-19 http://www.grex.org/~henced/coronavirus.html
unread,
coronavirus COVID-19
coronavirus COVID-19 http://www.grex.org/~henced/coronavirus.html
4/18/20
Ma...@getfucked.com
11/10/17
Uploads - What is wrong with Easynews
Looking for Star Trek Discovery season 1 Episodes 6 onwards in english. Why does it seem there are no
unread,
Uploads - What is wrong with Easynews
Looking for Star Trek Discovery season 1 Episodes 6 onwards in english. Why does it seem there are no
11/10/17
vasuin...@gmail.com
9/7/16
Hadoop training in bay area
Hadoop has moved far beyond its beginnings in web indexing and is now used in many businesses for a
unread,
Hadoop training in bay area
Hadoop has moved far beyond its beginnings in web indexing and is now used in many businesses for a
9/7/16
vasuin...@gmail.com
8/9/16
Hadoop Training In Bay Area
Hadoop is a very common and powerful (raised, flat supporting surface) for working with data, but it
unread,
Hadoop Training In Bay Area
Hadoop is a very common and powerful (raised, flat supporting surface) for working with data, but it
8/9/16
Nicholas Randall Forystek
7/12/16
.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
unread,
.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
7/12/16
nikhil nagpal
6/23/15
urgent job description
*Title: Database Production Support* *Location: Jersey City , NJ* *Duration: 6+* *Position: contract*
unread,
urgent job description
*Title: Database Production Support* *Location: Jersey City , NJ* *Duration: 6+* *Position: contract*
6/23/15
Gunnlaugur Þór Briem
2
1/29/15
EXPLAIN (without ANALYZE) taking 51 minutes for a large INSERT
We're still seeing this in our logs from time to time; 40 minutes this morning for an EXPLAIN.
unread,
EXPLAIN (without ANALYZE) taking 51 minutes for a large INSERT
We're still seeing this in our logs from time to time; 40 minutes this morning for an EXPLAIN.
1/29/15
林虎
7/25/14
Postgres: waiting for ExclusiveLock on extension of relation
We have a production DB server working for many centers, after we split db servers(buy a new server
unread,
Postgres: waiting for ExclusiveLock on extension of relation
We have a production DB server working for many centers, after we split db servers(buy a new server
7/25/14
marcin.r...@gmail.com
2
2/22/14
Improving index usage on very non selective index
I've noticed that removing LIMIT 1 is actually speeding up query a lot in EXISTS variant.
unread,
Improving index usage on very non selective index
I've noticed that removing LIMIT 1 is actually speeding up query a lot in EXISTS variant.
2/22/14
Joubin Houshyar
6/7/13
Context Switching
I am new to Postgres (love it!) and just heard a bit of potential 'FUD' regarding our
unread,
Context Switching
I am new to Postgres (love it!) and just heard a bit of potential 'FUD' regarding our
6/7/13
al...@hill.net.au
6/4/13
Query slower with to_tsquery in WHERE clause vs. in FROM clause
Hi, I have a couple of FTS queries which I *think* are equivalent, but one is about 20 times slower
unread,
Query slower with to_tsquery in WHERE clause vs. in FROM clause
Hi, I have a couple of FTS queries which I *think* are equivalent, but one is about 20 times slower
6/4/13
Ramesh naik
5/9/13
error while upgrading form 9.1 to 9.2
Hello all, we are getting struck with this error while upgrading while upgrading from 9.1 to 9.2 -
unread,
error while upgrading form 9.1 to 9.2
Hello all, we are getting struck with this error while upgrading while upgrading from 9.1 to 9.2 -
5/9/13
John Mudd
3
4/14/13
Postgres individual inserts, slow performance, delay
I think the "problem" is not slow INSERTs but "slow" transactions. I use quotes
unread,
Postgres individual inserts, slow performance, delay
I think the "problem" is not slow INSERTs but "slow" transactions. I use quotes
4/14/13
sun...@gmail.com
4/13/13
template1 vacumming
Hi, My databases are updated regularly so I am vacuuming frequently (every one hour). Recently i also
unread,
template1 vacumming
Hi, My databases are updated regularly so I am vacuuming frequently (every one hour). Recently i also
4/13/13
Tom Lane
4/11/13
Re: Performance ts_vector fulltext search
Luigi Saggese <luig...@gmail.com> writes: > I've configured 2 table like this > ...
unread,
Re: Performance ts_vector fulltext search
Luigi Saggese <luig...@gmail.com> writes: > I've configured 2 table like this > ...
4/11/13
Steve Singer
, …
Jeff Janes
8
4/11/13
slow bitmap heap scans on pg 9.2
On 13-04-10 07:54 PM, Steve Singer wrote: > On 13-04-10 02:06 PM, Jeff Janes wrote: >> On
unread,
slow bitmap heap scans on pg 9.2
On 13-04-10 07:54 PM, Steve Singer wrote: > On 13-04-10 02:06 PM, Jeff Janes wrote: >> On
4/11/13
Nik Tek
2
4/10/13
Postgres log(pg_logs) have lots of message
Hi Bambi, Thank you the prompt reply. This table is very volatile, lot of inserts/updates happen on
unread,
Postgres log(pg_logs) have lots of message
Hi Bambi, Thank you the prompt reply. This table is very volatile, lot of inserts/updates happen on
4/10/13
Tory M Blue
,
Shaun Thomas
3
4/10/13
Postgresql.conf file from like 7.x to 9.2
On Wed, Apr 10, 2013 at 2:42 PM, Shaun Thomas <sth...@optionshouse.com> wrote: On 04/10/2013
unread,
Postgresql.conf file from like 7.x to 9.2
On Wed, Apr 10, 2013 at 2:42 PM, Shaun Thomas <sth...@optionshouse.com> wrote: On 04/10/2013
4/10/13
Nik Tek
, …
hubert depesz lubaczewski
6
4/9/13
Find how much memory is postgres using
Hi Depesz, --Here is better one for Oracle by sga/pga. SELECT DECODE (GROUPING (nm), 1, 'total
unread,
Find how much memory is postgres using
Hi Depesz, --Here is better one for Oracle by sga/pga. SELECT DECODE (GROUPING (nm), 1, 'total
4/9/13
Dave Crooke
, …
Dave Johansen
22
4/8/13
[PERFORM] Picking out the most recent row using a time stamp column
On Fri, Apr 5, 2013 at 11:40 AM, Merlin Moncure <mmon...@gmail.com> wrote: > > On Fri,
unread,
[PERFORM] Picking out the most recent row using a time stamp column
On Fri, Apr 5, 2013 at 11:40 AM, Merlin Moncure <mmon...@gmail.com> wrote: > > On Fri,
4/8/13
Mark Davidson
, …
Jeff Janes
15
4/8/13
INDEX Performance Issue
Hi Jeff, I'ved tried this test using the -S flag './pgbench -c 4 -j 2 -T 600 -S pgbench'
unread,
INDEX Performance Issue
Hi Jeff, I'ved tried this test using the -S flag './pgbench -c 4 -j 2 -T 600 -S pgbench'
4/8/13
Nikolas Everett
, …
Tom Lane
12
4/8/13
Re: What happens between end of explain analyze and end of query execution ?
Jeff Janes <jeff....@gmail.com> writes: > On Sat, Apr 6, 2013 at 9:27 AM, Tom Lane <tgl
unread,
Re: What happens between end of explain analyze and end of query execution ?
Jeff Janes <jeff....@gmail.com> writes: > On Sat, Apr 6, 2013 at 9:27 AM, Tom Lane <tgl
4/8/13
Joe Van Dyk
, …
Julien Cigar
9
4/6/13
slow joins?
On 04/06/2013 16:22, Kevin Grittner wrote: > Julien Cigar <jci...@ulb.ac.be> wrote: >
unread,
slow joins?
On 04/06/2013 16:22, Kevin Grittner wrote: > Julien Cigar <jci...@ulb.ac.be> wrote: >
4/6/13
Bruce Momjian
, …
Ian Lawrence Barwick
9
4/4/13
Re: Postgres upgrade, security release, where?
2013/4/4 Mark Kirkwood <mark.k...@catalyst.net.nz>: > On 02/04/13 21:47, Mark Kirkwood
unread,
Re: Postgres upgrade, security release, where?
2013/4/4 Mark Kirkwood <mark.k...@catalyst.net.nz>: > On 02/04/13 21:47, Mark Kirkwood
4/4/13
AI Rumman
,
Kevin Grittner
2
4/3/13
Planner is getting wrong row count
AI Rumman <rumm...@gmail.com> wrote: > Why is the following query getting wrong estimation
unread,
Planner is getting wrong row count
AI Rumman <rumm...@gmail.com> wrote: > Why is the following query getting wrong estimation
4/3/13
Dieter Rehbein
, …
Vasilis Ventirozos
6
4/3/13
Join between 2 tables always executes a sequential scan on the larger table
Hello Dieter, If you are asking more than about 20% of the rows the optimizer will choose to do a seq
unread,
Join between 2 tables always executes a sequential scan on the larger table
Hello Dieter, If you are asking more than about 20% of the rows the optimizer will choose to do a seq
4/3/13
Armand du Plessis
, …
Mark Kirkwood
22
4/2/13
Problems with pg_locks explosion
It's now running as expected, I made a few other tweaks to get it to an operational state again.
unread,
Problems with pg_locks explosion
It's now running as expected, I made a few other tweaks to get it to an operational state again.
4/2/13
kelphet xiong
, …
Merlin Moncure
6
4/1/13
Question about postmaster's CPU usage
On Sat, Mar 30, 2013 at 11:00 PM, Kelphet Xiong <kel...@gmail.com> wrote: > I guess it is
unread,
Question about postmaster's CPU usage
On Sat, Mar 30, 2013 at 11:00 PM, Kelphet Xiong <kel...@gmail.com> wrote: > I guess it is
4/1/13
pg noob
,
Tom Lane
2
3/31/13
query plan estimate
pg noob <pgn...@gmail.com> writes: > I'm looking at this query plan, an excerpt of which
unread,
query plan estimate
pg noob <pgn...@gmail.com> writes: > I'm looking at this query plan, an excerpt of which
3/31/13