I believe yes / 0 are the default settings for synchronous commit and
commit_delay. ** (Interestingly the manual pages do not specify.) **
Sorry, I've just spotted the settings in the text. The statement (marked **) is
incorrect.
Defaults are yes/0.
On Sun, May 31, 2015 at 7:53 PM, Yves Dorfsman y...@zioup.com wrote:
That's the thing, even on an old laptop with a slow IDE disk, 273
individual
inserts should not take more than a second.
I think that would depend on settings such as synchronous_commit, commit_delay,
or whether 2-phase
Thanks everyone for your response. I will try these settings.
On Tue, Jun 2, 2015 at 1:28 PM, Graeme B. Bell g...@skogoglandskap.no
wrote:
I believe yes / 0 are the default settings for synchronous commit and
commit_delay. ** (Interestingly the manual pages do not specify.) **
Sorry, I've
On Mon, Jun 1, 2015 at 12:38 AM, Ashik S L ashiksl...@gmail.com wrote:
On 05/30/2015 09:46 AM, Ashik S L wrote:
We are using postgres SQL version 8.4.17..
Postgres DB szie is 900 MB and we are inserting 273 rows at once .and
each row is of 60 bytes.Every time we insert 16380 bytes of data.
On Mon, Jun 1, 2015 at 7:20 AM, Merlin Moncure mmonc...@gmail.com wrote:
On Mon, Jun 1, 2015 at 12:38 AM, Ashik S L ashiksl...@gmail.com wrote:
On 05/30/2015 09:46 AM, Ashik S L wrote:
We are using postgres SQL version 8.4.17..
Postgres DB szie is 900 MB and we are inserting 273 rows at once
On 05/30/2015 09:46 AM, Ashik S L wrote:
We are using postgres SQL version 8.4.17..
Postgres DB szie is 900 MB and we are inserting 273 rows at once .and
each row is of 60 bytes.Every time we insert 16380 bytes of data.
Way back when, I was inserting a lot of rows of date (millions of rows)
On 05/30/2015 09:46 AM, Ashik S L wrote:
We are using postgres SQL version 8.4.17..
Postgres DB szie is 900 MB and we are inserting 273 rows at once .and
each row is of 60 bytes.Every time we insert 16380 bytes of data.
Way back when, I was inserting a lot of rows of date (millions of rows)
On 2015-05-31 07:04, Jean-David Beyer wrote:
On 05/30/2015 09:46 AM, Ashik S L wrote:
We are using postgres SQL version 8.4.17..
Postgres DB szie is 900 MB and we are inserting 273 rows at once .and
each row is of 60 bytes.Every time we insert 16380 bytes of data.
Way back when, I was
We are using postgres SQL version 8.4.17..
Postgres DB szie is 900 MB and we are inserting 273 rows at once .and
each row is of 60 bytes.Every time we insert 16380 bytes of data.
I tried to make some config changes using above link. But I did not
see any improvement.
I made following changes in
Hi,
On 05/30/15 15:46, Ashik S L wrote:
We are using postgres SQL version 8.4.17..
FYI 8.4 is already unsupported for ~1 year, so you should consider
upgrading to a newer release. Also, the newest version in that branch is
8.4.22, so with 8.4.17 you're missing ~1 year of patches.
On 05/29/15 20:10, Ashik S L wrote:
Hi All,
I am using postgresDB on redhat machine which is having 4GB RAM
machine. As soon as it starts to Inserting rows into the postgres DB
it will reach 100%cpu. It will comedown to normal after 40 minutes. I
tried perform some tuning on the postgres DB,
Hi All,
I am using postgresDB on redhat machine which is having 4GB RAM
machine. As soon as it starts to Inserting rows into the postgres DB it
will reach 100%cpu. It will comedown to normal after 40 minutes. I tried perform
some tuning on the postgres DB, But result was same.I am not postgres
DB
machine. As soon as it starts to Inserting rows into the postgres DB it
will reach 100%cpu. It will comedown to normal after 40 minutes. I tried
perform
How many rows are you inserting at once? How (sql insert? copy? \copy? using a
temp or unlogged table?)?
--
http://yves.zioup.com
gpg:
13 matches
Mail list logo