On Sun, Jan 11, 2015 at 8:36 AM, deepak deepak...@gmail.com wrote:
Yes, I'm using a customized fork of 9.1.9.
Ok, adding back spi and dummy_seclabel makes all regression tests pass.
Please do not top-post, this makes the thread lose readability.
I now have one concern though. Inspite of
On Sun, Jan 11, 2015 at 7:38 AM, Brent Tubbs brent.tu...@gmail.com wrote:
I mixed up my email threads. I was following
http://michael.otacoo.com/postgresql-2/postgres-9-4-feature-highlight-logical-replication-protocol/
Looking back at it now, I can see that it didn't use psql to call
Hi,
I want to know what kind of hash function postgres is using currently, can
someone please explain the algorithm postgres is using for the hash
function in the hash join algorithm.
Thanks,
K.Ravikiran
OK, you might also want to look at the current values of shared_buffers,
temp_buffers work_mem in postgresql.conf.
If they seem correct/appropritate for your total shmmax memory
(kernel.shmmax parameter), then if the slowdown occurs again, monitor top
and see if it's really PostgreSQL that is
On Sat, Jan 10, 2015 at 8:54 PM, Melvin Davidson melvin6...@gmail.com
wrote:
Just curious. Have you checked that the tables are being vacuum/analyzed
periodically and that the statistics are up to date? Try running the
following query to verify:
A vacuum analyze runs every night and there
kolanpaka.ravikiran wrote
Hi,
I want to know what kind of hash function postgres is using currently, can
someone please explain the algorithm postgres is using for the hash
function in the hash join algorithm.
Thanks,
K.Ravikiran
Would you please just pick one of the mailing lists to
Thanks for your help here, on those blog posts, and in the pg_plugins repo.
This weekend I was able to make https://bitbucket.org/btubbs/decoder_json/
a thing.
On Sun, Jan 11, 2015 at 12:53 AM, Michael Paquier michael.paqu...@gmail.com
wrote:
On Sun, Jan 11, 2015 at 7:38 AM, Brent Tubbs