Kris Kennaway writes:
Well there you go then..you're trying to access a file that is larger
than RAM, so naturally you won't be able to fit it all in RAM, and
with 1GB less RAM in your system you'll spend much more time reading
bits of it from disk and later throwing them away.
Not to
On 3/30/06, Kris Kennaway [EMAIL PROTECTED] wrote:
Actually I seem to recall that on Linux with default settings fsync()
lies and does not actually sync data before returning, so maybe it's
worth turning off on FreeBSD too if you're comfortable with the
implications of this.
A few months ago
On Wed, 29 Mar 2006 19:09:26 -0600
Miguel [EMAIL PROTECTED] wrote:
Hi, im loading a lot of information to a postgresql 8.1.3 database,
im using the copy command, using the same file and version of
postgres in gentoo it spend a few minutes (~4-5), in freebsd
6.1-beta4 it has already spent 25
Beto,
i believe he has given up.
i would say that on a dedicated database machine 50-75%
dedicated(shared) memory is not overkill.
wasn't there some other switch which determined wether to page
shared-memory out?
regards,
usleep
On 4/3/06, Norberto Meijome [EMAIL PROTECTED] wrote:
On Wed,
i just thought of another possible cause:
what is the location of the to-be-imported file? local disk?
because if it is on the network, check your NIC if you are running at
the maximum rate, nfs buffers, etc ( i was fooled by such a situation
once ).
regards,
usleep
On 4/3/06, [EMAIL
On Mon, 3 Apr 2006 15:18:02 +0200
[EMAIL PROTECTED] wrote:
Beto,
i believe he has given up.
:( without knowing WHAT is the problem?
i would say that on a dedicated database machine 50-75%
dedicated(shared) memory is not overkill.
of course not. I am not sure I read his vmstat
[EMAIL PROTECTED] wrote:
Miguel,
you are not inserting into an indexed table, are you?
yes, i am...
is that a problem?
it used to be a problem, but since your gentoo box is doing the same
task in 4-5 minutes, i doubt it is currently the problem.
i seem to recall some
Miguel,
On Wed, Mar 29, 2006 at 07:09:26PM -0600, Miguel wrote:
Hi, im loading a lot of information to a postgresql 8.1.3 database, im
using the copy command, using the same file and version of postgres in
gentoo it spend a few minutes (~4-5), in freebsd 6.1-beta4 it has
already spent 25
Kris Kennaway wrote:
On Wed, Mar 29, 2006 at 07:09:26PM -0600, Miguel wrote:
Hi, im loading a lot of information to a postgresql 8.1.3 database, im
using the copy command, using the same file and version of postgres in
gentoo it spend a few minutes (~4-5), in freebsd 6.1-beta4 it has
[EMAIL PROTECTED] wrote:
Miguel,
On Wed, Mar 29, 2006 at 07:09:26PM -0600, Miguel wrote:
Hi, im loading a lot of information to a postgresql 8.1.3 database, im
using the copy command, using the same file and version of postgres in
gentoo it spend a few minutes (~4-5), in freebsd
On Thu, Mar 30, 2006 at 08:52:43AM -0600, Miguel wrote:
[EMAIL PROTECTED] wrote:
Miguel,
On Wed, Mar 29, 2006 at 07:09:26PM -0600, Miguel wrote:
Hi, im loading a lot of information to a postgresql 8.1.3 database, im
using the copy command, using the same file and version of
Miguel,
3.0G
i looked at your top-screenshot, i have the impression you could
dedicate far more memory to postgresql. maybe it would be usefull to
post your postgresql.conf ( this is in fact a postgresql question, but
i don't care ).
you might want to turn fsync off, my limited knowledge about
Kris,
3.0G
Well there you go then..you're trying to access a file that is larger
than RAM, so naturally you won't be able to fit it all in RAM, and
with 1GB less RAM in your system you'll spend much more time reading
bits of it from disk and later throwing them away.
i know a bit of
[EMAIL PROTECTED] wrote:
Kris,
3.0G
Well there you go then..you're trying to access a file that is larger
than RAM, so naturally you won't be able to fit it all in RAM, and
with 1GB less RAM in your system you'll spend much more time reading
bits of it from disk and later throwing
On Thu, Mar 30, 2006 at 09:41:51PM +0200, [EMAIL PROTECTED] wrote:
Miguel,
3.0G
i looked at your top-screenshot, i have the impression you could
dedicate far more memory to postgresql. maybe it would be usefull to
post your postgresql.conf ( this is in fact a postgresql question, but
i
Miguel,
Yes, it is a dump of a single table. i want to tranfer the data from one
server to another, and this is one of the biggest table.
ok, but gentoo performs the same task ok, so it is not a postgresql problem.
you have not confirmed wether the gentoo-box is running with the same
Kris,
Yes, this is my impression of the problem too. Any time your process
is waiting on disk I/O it is going to perform terribly (on any OS -
disks are slow), and the way to fix this is to make sure it does as
little I/O as possible (by allowing everything to be cached in RAM).
just for my
Miguel
attached is my config file, shared_buffers are 25% of total RAM
im guessing that this is a disk controlled bug or something, when i
execute any query involving many rows, the server response is very low,
ssh, su, even copy or rename a file, cpu usage remains ~87% idle though
you are
On Thu, Mar 30, 2006 at 10:49:01PM +0200, [EMAIL PROTECTED] wrote:
Kris,
Yes, this is my impression of the problem too. Any time your process
is waiting on disk I/O it is going to perform terribly (on any OS -
disks are slow), and the way to fix this is to make sure it does as
little
Miguel wrote:
.. postgresql is slow for me
and others wrote:
... you may have to dedicate more memory to it
Sorry for the above, but I haven't seen the beginning of the thread.
I don't know PostgreSQL much but I also has been recently running quite
simple program on one quite large table (2
[EMAIL PROTECTED] wrote:
Miguel
attached is my config file, shared_buffers are 25% of total RAM
im guessing that this is a disk controlled bug or something, when i
execute any query involving many rows, the server response is very low,
ssh, su, even copy or rename a file, cpu usage remains
Kris Kennaway [EMAIL PROTECTED] wrote:
On Thu, Mar 30, 2006 at 10:49:01PM +0200, [EMAIL PROTECTED] wrote:
Kris,
Yes, this is my impression of the problem too. Any time your process
is waiting on disk I/O it is going to perform terribly (on any OS -
disks are slow), and the way to
On Thu, Mar 30, 2006 at 07:24:37PM -0500, Bill Moran wrote:
Kris Kennaway [EMAIL PROTECTED] wrote:
On Thu, Mar 30, 2006 at 10:49:01PM +0200, [EMAIL PROTECTED] wrote:
Kris,
Yes, this is my impression of the problem too. Any time your process
is waiting on disk I/O it is going
Miguel [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
Miguel
attached is my config file, shared_buffers are 25% of total RAM
im guessing that this is a disk controlled bug or something, when i
execute any query involving many rows, the server response is very low,
ssh, su, even copy
Bill,
Actually I seem to recall that on Linux with default settings fsync()
lies and does not actually sync data before returning, so maybe it's
worth turning off on FreeBSD too if you're comfortable with the
implications of this.
If you have fsync off and the system crashes, your
Miguel,
you are not inserting into an indexed table, are you?
yes, i am...
is that a problem?
it used to be a problem, but since your gentoo box is doing the same
task in 4-5 minutes, i doubt it is currently the problem.
i seem to recall some speedup of the copyin-command in one of the
On Wed, Mar 29, 2006 at 07:09:26PM -0600, Miguel wrote:
Hi, im loading a lot of information to a postgresql 8.1.3 database, im
using the copy command, using the same file and version of postgres in
gentoo it spend a few minutes (~4-5), in freebsd 6.1-beta4 it has
already spent 25 minutes
27 matches
Mail list logo