El 03/11/11 11:42, Robert Haas escribió:
On Fri, Oct 28, 2011 at 9:39 AM, CS DBAcs_...@consistentstate.com wrote:
No parameters, one of them looks like this:
[ code snippet ]
It's hard to believe this is the real code, because SELECT without
INTO will bomb out inside a PL/pgsql function,
Are tables vacuumed often?
Bryan Buecking escribió:
On Tue, Apr 22, 2008 at 10:55:19AM -0500, Erik Jones wrote:
On Apr 22, 2008, at 10:31 AM, Bryan Buecking wrote:
max_connections = 2400
That is WAY too high. Get a real pooler, such as pgpool, and drop
that down to 1000 and
kevin kempter escribió:
Hi List;
I have a large tble (playback_device) with 6million rows in it. The
aff_id_tmp1 table has 600,000 rows.
I also have this query:
select distinct
tmp1.affiliate_id,
tmp1.name,
tmp1.description,
tmp1.create_dt,
tmp1.playback_device_id,
pf.segment_id
from
Jason Lustig escribió:
On Oct 16, 2007, at 10:22 AM, Richard Huxton wrote:
Add some lines to /etc/security/limits.conf to increase them.
Sorry for being somewhat of a linux novice -- but what is the best way
to do this? It doesn't seem to provide matching options from ulimit to
the
Carlos Moreno wrote:
Tom Lane wrote:
Carlos Moreno [EMAIL PROTECTED] writes:
I would have expected a mind-blowing increase in responsiveness and
overall performance. However, that's not the case --- if I didn't know
better, I'd probably tend to say that it is indeed the opposite
Gauri Kanekar wrote:
Hi List,
Machine was down due to some hardware problem.
After then when i issue this command /usr/local/pgsql/bin/psql -l
its giving me the following error
psql: could not connect to server: No such file or directory
Is the server running locally and
Gauri Kanekar wrote:
Thanks,
But how to start postgres server
On 2/26/07, *Rodrigo Gonzalez* [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Gauri Kanekar wrote:
Hi List,
Machine was down due to some hardware problem.
After then when i issue this command