Re: [PERFORM] pgbouncer issue

and nobody else has complained, it's probably not too important as far as day to day pgbouncer use. :) - -- Greg Sabino Mullane g...@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201507051040 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

Re: [PERFORM] Configuration Recommendations

fsync = off ;) - -- Greg Sabino Mullane g...@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201205151351 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iEYEAREDAAYFAk+yl8YACgkQvJuQZxSWSshB+QCghfweMspFIqmP4rLv6

Re: [PERFORM] Configuration Recommendations

, separating pg_xlog, etc. - -- Greg Sabino Mullane g...@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201204251304 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iEYEAREDAAYFAk

Re: [PERFORM] random_page_cost = 2.0 on Heroku Postgres

decrement rpc slowly and find out at one points it changes, which would be more interesting than testing arbitrary numbers. Would lead to some really sweet graphs as well. :) - -- Greg Sabino Mullane g...@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201202082338 http

Re: [PERFORM] Master/Slave, DB separation or just spend $$$?

. Keep in mind that both are asynchronous, so changes won't appear on the slaves at the same time as the master, but the delay is typically measured in seconds. - -- Greg Sabino Mullane g...@turnstep.com End Point Corporation PGP Key: 0x14964AC8 200907221229 http://biglumber.com/x/web?pk

Re: [PERFORM] Postgres replication: dump/restore, PITR, Slony,...?

get pushed to at one time, from 1 up to all of them. - -- Greg Sabino Mullane g...@turnstep.com End Point Corporation PGP Key: 0x14964AC8 200906121509 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iEYEAREDAAYFAkoyqFkACgkQvJuQZxSWSsjB8ACffcQRD

Re: [PERFORM] Postgres replication: dump/restore, PITR, Slony,...?

-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Then there are Slony-I, Buchardo, Mamoth Replicator from CMO, simple replication in Postgres 8.4 and other projects... CMO? :) Buchardo? :) - -- Greg Sabino Mullane g...@turnstep.com End Point Corporation PGP Key: 0x14964AC8 200906111229

Re: [PERFORM] Best replication solution?

or SOLR, caching solutions such as Squid or Varnish, moving the slaves to the cloud, etc.) - -- Greg Sabino Mullane g...@turnstep.com End Point Corporation PGP Key: 0x14964AC8 200904052158 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE

Re: [PERFORM] Perl/DBI vs Native

in which the socket is not where you expect it to be: $dbh = DBI-connect('dbi:Pg:dbname=test;host=/var/local/sockets', $user, $pass, {AutoCommit=0, RaiseError=1}); - -- Greg Sabino Mullane [EMAIL PROTECTED] End Point Corporation PGP Key: 0x14964AC8 200807221248 http://biglumber.com/x/web?pk

Re: [PERFORM] Perl/DBI vs Native

at each point with: $dbh-trace('SQL,libpq'); To get back to the original poster's complaint, you may want to figure out why the difference is so great for a prepared plan. It may be that you need to cast the placeholder(s) to a specific type, for example. - -- Greg Sabino Mullane [EMAIL PROTECTED

Re: [PERFORM] How to avoid vacuuming a huge logging table

(relname)||';' FROM pg_class c, pg_namespace n WHERE relkind = 'r' AND relnamespace = n.oid AND nspname = 'novac' ORDER BY 1; ... Just flip the equality operator, and you've got a way to vacuum just those excluded tables, for example once a week during a slow time. - -- Greg Sabino

Re: [PERFORM] Perl DBD and an alarming problem

There may be another way around it, if you can tell us some more about what exactly it is you are trying to do. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200511161830 http

Re: [PERFORM] Prepared statement not using index

it in? - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200509120925 https://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iEYEARECAAYFAkMlgdAACgkQvJuQZxSWSsjMlQCePc4dpE0BCT3W//y/N9uolkmK ViIAnjR1fF14KbP+cX+xV8lmdlL6Be2k =NtXw -END

Re: [PERFORM] Configurator project launched

cvs interface). - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200506242107 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFCvK6AvJuQZxSWSsgRApFcAKDVQ5OdVgVc2PmY/p719teJ3BqNjQCgrgyx +w+w8GCGXUFO+5dxi5RPwKo= =eG7M -END

Re: [PERFORM] Configurator project launched

changed in the default conf file from 7.4.7 and 8.0.1. It will also allow you to rewrite the conf files in a standard way. I'm hoping to roll this into 1.44 or 1.45 or DBD::Pg. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200506212046 http://biglumber.com/x/web?pk

Re: [PERFORM] help on explain analyse in psql 7.1.3 (linux)

to upgrade... :) - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200504072129 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFCVd69vJuQZxSWSsgRAvRHAJ9T1uxfWEnHSNI/+iiiHiJ2I1IGUgCggMYb tjDwzfseK3aDAKHI5Ko1S/Q= =AvKY

Re: COPY Hacks (WAS: RE: [PERFORM] Postgresql vs SQLserver for this application ?)

: it certainly does no harm as long as you make sure the string you send always *end* in a newline. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200504072201 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE

Re: [PERFORM] Changing the random_page_cost default (was: cpu_tuple_cost)

to reach consensus here. :) - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200503141727 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFCNhFAvJuQZxSWSsgRAgZiAJ9947emxFoMMXKooJHi2ZPIQr9xGACgjaFf hBCPTuHZwGFzomf1Z1TDpVo= =KX9t

Re: [PERFORM] Changing the random_page_cost default (was: cpu_tuple_cost)

model and perhaps make the defaults work better for my queries and other people with databaes like mine. (fairly simple schema, not too large (~2 Gig total), SCSI, medium to high complexity queries, good amount of RAM available)? - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8

Re: [PERFORM] PostgreSQL vs. Oracle vs. Microsoft

: development, testing, QA, etc. Is it really as cheap as 5K? I've heard that for any fairly modern system, it's much more, but that may be wrong. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200501122029 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN

Re: [PERFORM] Does PostgreSQL run with Oracle?

had experience with both. My gut feeling is not just as fast, but often times faster. I've found very few cases in which Oracle was faster, and that was usually due to some easily spotted difference such as tablespace support. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8

Re: [PERFORM] Deleting certain duplicates

original deletion query may work as is, with the addition of an oid index. Perhaps try an EXPLAIN on it. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200404200706 -BEGIN PGP SIGNATURE- iD8DBQFAhQVWvJuQZxSWSsgRAvLEAKDCVcX3Llm8JgszI/BBC1SobtjVawCfVGKu ERcV5J2JolwgZRhMbXnNM90