Re: [PERFORM] The state of PG replication in 2008/Q2?

2008-08-21 Thread salman
of it a few times and have had no problems. -salman -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] Problem with 11 M records table

2008-05-13 Thread salman
mentioned on one of these lists that with offset, all the rows in between still have to be read. So, you may get better results if you use a 'where id 1' clause in the query. -salman -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your

Re: [PERFORM] Replication Syatem

2008-04-28 Thread salman
windows (we're a 24/7 shop) and do clustering and other tasks on our DB to reclaim space, etc. -salman -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

[PERFORM] Question about CLUSTER

2008-02-11 Thread salman
assuming that idx_tup_read would probably be the best choice, but want to get other opinions before proceeding. Can anyone point me to docs which explain this better? -salman ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner