I want to use PostgreSQL for my standalone .NET
Windows application. I downloaded PostgreSQL Advanced Server from
EnterpriseDB's website and it is very smooth. The GUI also very good.
But I suspect how along EnterpriseDB will support it.
The second option is to download from p
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
On 29 October 2010 21:52, Rob Richardson 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
> (
> charge integer,
> ela
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" i
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 final
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 conc
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 searc
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. Talk
On 10/29/2010 07:32 AM, Karl Pickett wrote:
On Fri, Oct 29, 2010 at 8:58 AM, Adrian Klaver 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 prim
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
Fred Miller 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 (pgsql-general@postgresql.org)
To make
On 10/29/2010 9:49 AM, Merlin Moncure wrote:
On Thu, Oct 28, 2010 at 10:04 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 e
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,
> elap
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
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 Contri
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 ab
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,
elapsed_time integer, -- number of elapsed minutes since data bega
On October 29, 2010, "Dean Gibson (DB Administrator)"
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 "pointed" (vi
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, befor
On October 29, 2010, "Dean Gibson (DB Administrator)"
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 nuisance.
I'm curio
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" serv
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
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 Fri, 29 Oct 2010 10:21:14 -0400
Vick Khera wrote:
> On Thu, Oct 28, 2010 at 1:06 PM, Ivan Sergio Borgonovo
> 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_relat
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
pg_r
On Thu, Oct 28, 2010 at 10:04 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
> *
On Fri, Oct 29, 2010 at 8:58 AM, Adrian Klaver 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 do
>> incremen
"Jan C." 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 constraint !
Jacqui Caren-home 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 insert into ... as s
On Thu, Oct 28, 2010 at 1:06 PM, Ivan Sergio Borgonovo
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
> default_statistics_target = 30
>
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
n Fri, Oct 29, 2010 at 2:53 AM, Peter Geoghegan
wrote:
> On 29 October 2010 03:04, 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
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
On Fri, Oct 29, 2010 at 2:40 PM, David Balažic 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 titles of som
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
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: Ca
On 29 October 2010 14:34, AI Rumman 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 pointed out, p
At present,
checkpoint_segment=3
checkpoint_timeout=300
On 10/29/10, Thom Brown wrote:
> On 29 October 2010 13:24, AI Rumman 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 a
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/
http:/
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 happ
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.
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
PostgreSQL
On 29 October 2010 13:24, AI Rumman 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 analyzing the nmon
> spr
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 w
On Fri, 29 Oct 2010 08:19:27 +0200
Alban Hertroys 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 catalog_items {
itemid bigint prima
Hi,
On 29 October 2010 11:46, Jacqui Caren-home 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 here -
http://www.postgr
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 pu
On 29 October 2010 03:04, 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 eve
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 ins
48 matches
Mail list logo
