Dear Team,
I have set path like
export LD_LIBRARY_PATH="/opt/PostgreSQL/9.1/lib/"
Then no warnings :)
On Sat, Dec 22, 2012 at 1:05 PM, Hariraman Jayaraj
wrote:
> Dear Team,
>
> I have downloaded postgres 9.1.6 32bit from Enterprise DB site (One Click
> Installer) and installed the same in Suse
> and here's my query
>
> select * from ticket
> where created between '2012-12-19 00:00:00' and '2012-12-20 00:00:00'
>
> This was working fine until the number of records started to grow (about 5
> million) and now it's taking forever to return.
>
> Explain analyze reveals this:
>
> "Inde
On 2012-12-22 13:06:21 +0100, Alban Hertroys wrote:
> > and here's my query
> >
> > select * from ticket
> > where created between '2012-12-19 00:00:00' and '2012-12-20 00:00:00'
> >
> > This was working fine until the number of records started to grow (about 5
> > million) and now it's taking fo
We ran into a production issue during our maintenance window when I switched
over LifeKeeper/PostgreSQL nodes from one to another. We noticed that the
database was 1000 times slower than it usually is, then realized that the
log_min_messages setting was set to 'debug5' for no reason.
Facts:
T
