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 wrote:
> On Sun, Jan 11, 2015 at 7:38 AM, Brent Tubbs
> wrote:
> > I mixed up my ema
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 l
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 sl
On Sat, Jan 10, 2015 at 8:54 PM, Melvin Davidson
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 would not have bee
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
On Sun, Jan 11, 2015 at 7:38 AM, Brent Tubbs 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
> START_REPLICATION.
That'
On Sun, Jan 11, 2015 at 8:36 AM, deepak 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 adding pgcrypto to the
