Hi all,
I've attached all the query in query.sql
I'm using postgres 7.3.4 on Linux version 2.4.26-custom
( /proc/sys/vm/overcommit_memory = 0 this time )
free :
total used free sharedbuffers cached
Mem: 18102121767384 42828 0
For starters,
shared_buffers = 110592
wal_buffers = 400
sort_mem = 30720
vacuum_mem = 10240
checkpoint_segments = 30
commit_delay = 5000
commit_siblings = 100
effective_cache_size = 201413
Try more like this:
shared_buffers =
On 8/24/2004 1:08 AM, my ho wrote:
--- Jan Wieck <[EMAIL PROTECTED]> wrote:
On 8/17/2004 8:44 PM, my thi ho wrote:
> Hi,
> I am working on a project which explore postgresql
to
> store multimedia data.
> In details, i am trying to work with the buffer
> management part of postgres source code. And
Stef wrote:
> Christopher Kings-Lynne mentioned :
> => sort_mem = 4096
>
> Reducing sort_mem to 4096 seems to make it run in a reasonable time
> again. Any idea why? The database does a whole lot of huge sorts
> every day, so I thought upping this parameter would help.
>
> A couple of queries do se
Stef <[EMAIL PROTECTED]> writes:
> Reducing sort_mem to 4096 seems to make it run in a reasonable time
> again. Any idea why? The database does a whole lot of huge sorts
> every day, so I thought upping this parameter would help.
Not if you haven't got the RAM to support it :-(
Another thing you
Do you think that adopting the "chip tuning" product
postgresql could increase the performances as well ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail com
Stef wrote:
Christopher Kings-Lynne mentioned :
=> sort_mem = 4096
Reducing sort_mem to 4096 seems to make it run in a reasonable time
again. Any idea why? The database does a whole lot of huge sorts
every day, so I thought upping this parameter would help.
A couple of queries do seem to run slower
Hi list,
I have a database with 1M "people" in it. Each person has about 20
attributes, such as height, weight, eye color, etc. I need to be able to
search for people based on these attributes. A search can be conducted
on one attribute, all attributes, or any number in between. How would
_you_ do
Folks,
> I've discussed these attempts with people in #postgresql on
> irc.freenode.net. Agliodbs (I presume you know who this is) was very
> helpful, but in end was at a loss. I find myself in the same postition
> at this time. He suggested I contact this list.
There's a couple of issues here to
Daniel Ceregatti wrote:
Hi list,
I have a database with 1M "people" in it. Each person has about 20
attributes, such as height, weight, eye color, etc. I need to be able to
search for people based on these attributes. A search can be conducted
on one attribute, all attributes, or any number in betw
> Tom Lane answered to that question. The code in
> question does resolve
> "localhost" with getaddrinfo() and then tries to
> create and bind a UDP
> socket to all returned addresses. For some reason
> "localhost" on your
> system resolves to an address that is not available
> for bind(2).
I t
11 matches
Mail list logo
