On 28 Oct 2010, at 19:28, Ivan Sergio Borgonovo wrote:
I'm running this query when I'm the only user and this should be the
only thing running.
update catalog_items
...
from (
select a.id, a.codice, a.codicealt,
...
from
import.Articoli a
left join
I have inherited an application that populates a number of
temp.y tables using create table ... as select ...
This is taking roughly five to ten minutes to run
As this process hammers the database, I can only run benchmarks at night so
am asking here if anyone know if
create table ...; then
On 29 October 2010 03:04, Karl Pickett karl.pick...@gmail.com wrote:
Hello Postgres Hackers,
We have a simple 'event log' table that is insert only (by multiple
concurrent clients). It has an integer primary key. We want to do
incremental queries of this table every 5 minutes or so, i.e.
Hello,
I have dump of an entire database and I'm trying to restore only one named
table:
pg_restore --format=c -C -U myUser -d myDB /tmp/mydump -t my_table
The command completes without errors/warnings but the resulting table in the
database is missing the PKEY constraint !
Is this done on
Hi,
On 29 October 2010 11:46, Jacqui Caren-home jacqui.ca...@ntlworld.com wrote:
I have inherited an application that populates a number of
temp.y tables using create table ... as select ...
What is the principle of creating this temp.y tables?
May be table partitioning is better to implement
On Fri, 29 Oct 2010 08:19:27 +0200
Alban Hertroys dal...@solfertje.student.utwente.nl wrote:
I've to amend the one user connected assumption.
But I'm really sure there is no other process writing on
catalog_items.
There is a process that read catalog_items and write on another
table.
create
I am using Postgresql 8.1 in 8-cpu cores with 32 gb ram with CestOS 5.
I have different DBs in the system and the large one is 12 GB and it is a
CRM DB and heavily used.
Every day after 1 pm the system gets slow and after analyzing the nmon
spreadsheet, I found that IO spike at that period.
Users
On 29 October 2010 13:24, AI Rumman rumman...@gmail.com wrote:
I am using Postgresql 8.1 in 8-cpu cores with 32 gb ram with CestOS 5.
I have different DBs in the system and the large one is 12 GB and it is a
CRM DB and heavily used.
Every day after 1 pm the system gets slow and after
On Fri, 2010-10-29 at 18:24 +0600, AI Rumman wrote:
I am using Postgresql 8.1 in 8-cpu cores with 32 gb ram with CestOS 5.
snip
In addition to what Thom wrote, please note that checkpoints in pre-8.3
negative effect on disk I/O -- you may see spikes during checkpoints.
--
Devrim GÜNDÜZ
Hi all
I'm testing a warm standby setup using PostgreSQL 9 x64 on Windows 2008 R2.
The problem is that when I put the trigger file on the location
specified in the parameter
'trigger_file' of the recovery.conf, nothing happens. No log entries,
the recovery just continues
as if nothing has
On 2010-10-28 22.50, Joshua D. Drake wrote:
Hey,
Based on the discussion here:
http://www.commandprompt.com/blogs/joshua_drake/2010/10/users_versus_customers_-_you_dont_need_no_stinking_replication/
http://thebuild.com/blog/2010/10/28/small-postgresql-installations-and-9-0-replication/
At present,
checkpoint_segment=3
checkpoint_timeout=300
On 10/29/10, Thom Brown t...@linux.com wrote:
On 29 October 2010 13:24, AI Rumman rumman...@gmail.com wrote:
I am using Postgresql 8.1 in 8-cpu cores with 32 gb ram with CestOS 5.
I have different DBs in the system and the large one is
On 29 October 2010 14:34, AI Rumman rumman...@gmail.com wrote:
At present,
checkpoint_segment=3
checkpoint_timeout=300
I'd recommend at least setting checkpoint_segments to 12 and you might want
to increase checkpoint_timeout too, although not too high. Maybe try
doubling it.
And as Devrim
Hi!
http://get.enterprisedb.com/postgresql/postgresql-9.0.1-1-windows.exe
Upon starting the abov installer, I get a dialog titled
Microsoft Visual C++ 2008 Redistributable - x86 9.0.30729.4148
It lists the window titles of some processes, like MS Outlook, Firefox, Eclipse
and has 3 buttons:
On 10/29/2010 10:04 AM, Karl Pickett wrote:
Hello Postgres Hackers,
We have a simple 'event log' table that is insert only (by multiple
concurrent clients). It has an integer primary key. We want to do
incremental queries of this table every 5 minutes or so, i.e. select
* from events where id
On Fri, Oct 29, 2010 at 2:40 PM, David Balažic xerc...@gmail.com wrote:
Hi!
http://get.enterprisedb.com/postgresql/postgresql-9.0.1-1-windows.exe
Upon starting the abov installer, I get a dialog titled
Microsoft Visual C++ 2008 Redistributable - x86 9.0.30729.4148
It lists the window
On Thursday 28 October 2010 7:04:48 pm Karl Pickett wrote:
Hello Postgres Hackers,
We have a simple 'event log' table that is insert only (by multiple
concurrent clients). It has an integer primary key. We want to do
incremental queries of this table every 5 minutes or so, i.e. select
*
n Fri, Oct 29, 2010 at 2:53 AM, Peter Geoghegan
peter.geoghega...@gmail.com wrote:
On 29 October 2010 03:04, Karl Pickett karl.pick...@gmail.com wrote:
Hello Postgres Hackers,
We have a simple 'event log' table that is insert only (by multiple
concurrent clients). It has an integer primary
Two days ago I upgraded five DB boxes (for load balancing) from 8.3.0 to
9.0.1 in order to use replication. The replication configuration went
reasonably well, and now all the four hot_standby servers are
(streaming) replicating just fine from the primary DB server. If the
primary fails and I
On Thu, Oct 28, 2010 at 1:06 PM, Ivan Sergio Borgonovo
m...@webthatworks.it wrote:
What I'm planning to do is:
max_connections = 5
shared_buffers = 240M
work_mem = 90MB
maintenance_work_mem = 1GB
max_fsm_pages = 437616
max_fsm_relations = 1200
checkpoint_segments = 70
Jacqui Caren-home jacqui.ca...@ntlworld.com writes:
I have inherited an application that populates a number of
temp.y tables using create table ... as select ...
As this process hammers the database, I can only run benchmarks at night so
am asking here if anyone know if
create table ...; then
Jan C. chal...@gmail.com writes:
I have dump of an entire database and I'm trying to restore only one named
table:
pg_restore --format=c -C -U myUser -d myDB /tmp/mydump -t my_table
The command completes without errors/warnings but the resulting table in the
database is missing the PKEY
On Fri, Oct 29, 2010 at 8:58 AM, Adrian Klaver adrian.kla...@gmail.com wrote:
On Thursday 28 October 2010 7:04:48 pm Karl Pickett wrote:
Hello Postgres Hackers,
We have a simple 'event log' table that is insert only (by multiple
concurrent clients). It has an integer primary key. We want to
On Thu, Oct 28, 2010 at 10:04 PM, Karl Pickett karl.pick...@gmail.com wrote:
Hello Postgres Hackers,
We have a simple 'event log' table that is insert only (by multiple
concurrent clients). It has an integer primary key. We want to do
incremental queries of this table every 5 minutes or so,
So I'd have to do:
pg_restore -l /tmp/mydump | grep my_table /tmp/mytable_lines
pg_restore --format=c -C -U myUser -d myDB /tmp/mydump -L /tmp/mytable_lines
It looks like I have to use grep to look for my table and not -t
my_table because the PKEY constraint is NOT listed when I do
On Fri, 29 Oct 2010 10:21:14 -0400
Vick Khera vi...@khera.org wrote:
On Thu, Oct 28, 2010 at 1:06 PM, Ivan Sergio Borgonovo
m...@webthatworks.it wrote:
What I'm planning to do is:
max_connections = 5
shared_buffers = 240M
work_mem = 90MB
maintenance_work_mem = 1GB
max_fsm_pages =
hello,
does anyone have a C implementation of xor(bytea,bytea)?
i need to xor aggregate the results of a digest.
an xor operator for bytea would be great too, but i'd be happy with
just the function.
i've searched and found past posts about xor'ing text, or bit -
bytea casting. it seemed the
On 10/28/10 11:25 PM, Dean Gibson AE7Q wrote:
Two days ago I upgraded five DB boxes (for load balancing) from 8.3.0
to 9.0.1 in order to use replication. The replication configuration
went reasonably well, and now all the four hot_standby servers are
(streaming) replicating just fine from the
Oops; previously sent from the wrong eMail address, so I don't know if
this actually got sent:
Two days ago I upgraded five DB boxes (for load balancing) from 8.3.0 to
9.0.1 in order to use replication. The replication configuration went
reasonably well, and now all the four hot_standby
On October 29, 2010, Dean Gibson (DB Administrator)
postgre...@ultimeth.com wrote:
My question is, how do I configure the other three (still) hot_standby
boxes to now use the new primary? Clearly I can change the
recovery.conf file on each standby box, but that seems like an
unnecessary
On 2010-10-29 11:17, Alan Hodgson wrote:
I'm curious about this too. It seems that currently I'd have to
rebuild any additional slaves basically from scratch to use the new
master.
I think so long as you pointed (via primary_conninfo) the additional
slaves to the new (pending) master, before
On October 29, 2010, Dean Gibson (DB Administrator)
postgre...@ultimeth.com wrote:
On 2010-10-29 11:17, Alan Hodgson wrote:
I'm curious about this too. It seems that currently I'd have to
rebuild any additional slaves basically from scratch to use the new
master.
I think so long as you
This one aught to be good!
The tool is after all called pgAdmin rather that say pgBrowser.
I think you have a teaching opportunity here. There is a feature for
getting the first N rows that might help (a lot). There is
query-by-example as well.
I can't really imagine the value of being able to
On Fri, 2010-10-29 at 15:02 -0600, Rob Sargent wrote:
Not saying this excuses the crash necessarily or more importantly the
poor error message. One might find a stack trace in the system error log?
Think probably ran out of memory. 16M records? Really?
JD
--
PostgreSQL.org Major
What is the max number of tables allowed in a union (in 8.4 and 9.0)?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Le 29/10/2010 13:52, Rob Richardson a écrit :
A customer was reviewing the database that supports the application we
have provided. One of the tables is very simple, but has over 16
million records. Here is the table's definition:
CREATE TABLE feedback
(
charge integer,
On 10/29/2010 9:49 AM, Merlin Moncure wrote:
On Thu, Oct 28, 2010 at 10:04 PM, Karl Pickettkarl.pick...@gmail.com wrote:
Hello Postgres Hackers,
We have a simple 'event log' table that is insert only (by multiple
concurrent clients). It has an integer primary key. We want to do
incremental
Fred Miller f...@frederickmiller.com writes:
What is the max number of tables allowed in a union (in 8.4 and 9.0)?
There's no specific limit. I doubt you'd get good performance with
thousands ...
regards, tom lane
--
Sent via pgsql-general mailing list
I have a Postgres 9 server running on a server out on the Internet and
I connect to it with pgAdmin on OS/X over an SSL connection.
I notice if I keep the connection open and idle for maybe an hour or
so, when I try to run a query it either times out or pgAdmin just
kinda freezes up and I have to
On 10/29/2010 07:32 AM, Karl Pickett wrote:
On Fri, Oct 29, 2010 at 8:58 AM, Adrian Klaveradrian.kla...@gmail.com wrote:
On Thursday 28 October 2010 7:04:48 pm Karl Pickett wrote:
Hello Postgres Hackers,
We have a simple 'event log' table that is insert only (by multiple
concurrent clients).
PGDay is scheduled at this year's Southern California Linux Exposition
(SCALE) held in the LAX Hilton Hotel in the city of Los Angeles,
California, on Friday February 25th, 2010.
We are looking for talks designed for a general audience of web
developers, sysadmins, DBAs and open source users.
Has anyone had any experience with writing an interface between Paradox
(199X's vintage) and postgresql. I have the need to be able to read a
paradox database to see it's structure, replicate that structure in
postgresql and finally transfer the data to postgresql.
I have not done any
On Fri, 2010-10-29 at 16:57 -0500, Andy Colson wrote:
begin
insert into logged select * from events where processed = false;
update events set processed = true where processed = false;
commit;
There's a race condition there. The SELECT in the INSERT statement may
read 5 tuples, then a
On Fri, 2010-10-29 at 18:34 -0500, Dale Seaburg wrote:
Has anyone had any experience with writing an interface between Paradox
(199X's vintage) and postgresql. I have the need to be able to read a
paradox database to see it's structure, replicate that structure in
postgresql and finally
On Friday 29 October 2010 5:16:14 pm Joshua D. Drake wrote:
On Fri, 2010-10-29 at 18:34 -0500, Dale Seaburg wrote:
Has anyone had any experience with writing an interface between Paradox
(199X's vintage) and postgresql. I have the need to be able to read a
paradox database to see it's
On 29 October 2010 21:52, Rob Richardson rob.richard...@rad-con.com wrote:
A customer was reviewing the database that supports the application we have
provided. One of the tables is very simple, but has over 16 million
records. Here is the table's definition:
CREATE TABLE feedback
(
What is the maximum number of tables allowed in a union in 8.4 and 9.0?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
47 matches
Mail list logo