Thanks,
It does look like an incorrect prediction. Looking again, I think it's the row
estimate for the join that's out - the planner estimates one row returned, in
which case a nested join would probably make sense, whereas in fact there are
23.
However it's a generated (user created) query,
On Sun, Nov 6, 2011 at 11:04 PM, Jan Geluk (Collis) ge...@collis.nl wrote:
Dear all,
For our customer in Dubai, we are looking for references of PostgreSQL
implementations in the Middle East, preferably in the GCC countries,
preferably in the United Arab Emirates (Dubai / Abu Dhabi).
I have a behaviour similar to this
http://archives.postgresql.org/pgsql-bugs/2007-09/msg00017.php
create language plpgsql;
create schema test1;
create schema test2;
create table test1.a(a varchar(3) unique);
create table test2.a(a varchar(3) unique);
create or replace function test_insert()
On Thu, Nov 3, 2011 at 11:56 PM, Michael Musenbrock redea...@gmx.net wrote:
But I have not
found any information if this is possible to create a trigger on a
constraint violation, and if yes, how could that be done?
You want to use the special type of CONSTRAINT trigger.
Hello
I've been looking for ways to optimize a query.
I have a table with 120,000 records. When searched on:
select * from big_table
takes to run: 3 min.
I wanted to use cursors and the query with big_table, it taked 11
minutes. It caught my attention on a small_table (100 records)
Hello
cursors are optimized for fast return of first row and there are no
expect to return complete result.
This can be a problem
try to set cursor_tuple_fraction to 1
Regards
Pavel Stehule
2011/11/7 Ing.Edmundo.Robles.Lopez erob...@sensacd.com.mx:
Hello
I've been looking for ways to
2011/11/7 Ivan Sergio Borgonovo m...@webthatworks.it:
On Mon, 7 Nov 2011 17:55:11 +0100
Pavel Stehule pavel.steh...@gmail.com wrote:
Hello
this is know bug/feature based on caching plans
What puzzled me is I'm operating in a similar way in a different
system and I'm not experiencing the
Hello,
I had the same issue and could solve it the following way.
open a terminal,
cd /usr/lib
sudo mv libpq.5.dylib libpq.5.dylib-ORG
sudo ln -s libpq.5.3.dylib libpq.5.dylib
Cheers,
Stéphane
--
View this message in context:
Hello everyone,
Is the pages hosted at http://projects.postgresql.org/ offline? I can't
access any of them.
Tks in advance.
I have a function, call it 'functionMain'. And I have several tables that each
have trigger functions. Each trigger function needs to call 'functionMain'
(with different parameters).
table A = trigger function A == functionMain
table B = trigger function B == functionMain
table C = trigger
On Mon, 2011-11-07 at 17:10 -0200, Leonardo Carneiro wrote:
Is the pages hosted at http://projects.postgresql.org/ offline? I
can't access any of them.
http://archives.postgresql.org/pgsql-www/2011-11/msg00016.php
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB:
Hello
2011/11/7 Lori Corbani lori.corb...@jax.org:
I have a function, call it 'functionMain'. And I have several tables that
each have trigger functions. Each trigger function needs to call
'functionMain' (with different parameters).
table A = trigger function A == functionMain
table B
Hi.
Is any application, which works as www server on client's side, and
loads pages from postgresql database? (free or commercial)
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
I've been using a query on Postgres 8.4 with a negative OFFSET, which
works fine:
SELECT DISTINCT s.* FROM s WHERE ... ORDER BY s.bday ASC, s.name
ASC LIMIT 15 OFFSET -15
When I run the same query on Postgres 9.1, I get an error:
ERROR: OFFSET must not be negative
Question:
1. Was this
On Mon, Nov 7, 2011 at 3:47 PM, Robert James srobertja...@gmail.com wrote:
I've been using a query on Postgres 8.4 with a negative OFFSET, which
works fine:
SELECT DISTINCT s.* FROM s WHERE ... ORDER BY s.bday ASC, s.name
ASC LIMIT 15 OFFSET -15
When I run the same query on Postgres 9.1,
I am trying to restore a dump created with pg_dump, both source and
destination are Postgres 9.1.1 albeit different machines (source is Linux,
destination is OS X).
$ pg_restore -U postgres -Fc -d batch_api_production
200708_batch_api_production.dump.sql
pg_restore: [custom archiver]
On Mon, 7 Nov 2011 19:07:29 +0100
Pavel Stehule pavel.steh...@gmail.com wrote:
2011/11/7 Ivan Sergio Borgonovo m...@webthatworks.it:
On Mon, 7 Nov 2011 17:55:11 +0100
Pavel Stehule pavel.steh...@gmail.com wrote:
Hello
this is know bug/feature based on caching plans
What puzzled
On 07/11/2011 20:13, pasman pasmański wrote:
Hi.
Is any application, which works as www server on client's side, and
loads pages from postgresql database? (free or commercial)
Many. Depends on what you want to do care to be a bit more specific?
Ray.
--
Raymond O'Donnell :: Galway
Does simple SELECT query like
select * from tableX
(without FOR UPDATE) opens an implicit transaction when issued?
Thanks,
--
Edson Carlos Ericksson Richter
Am 2011-11-07 16:06, schrieb Richard Broersma:
On Thu, Nov 3, 2011 at 11:56 PM, Michael Musenbrock redea...@gmx.net wrote:
But I have not
found any information if this is possible to create a trigger on a
constraint violation, and if yes, how could that be done?
You want to use the special
On 11/07/11 2:41 PM, Edson Richter wrote:
Does simple SELECT query like
select * from tableX
(without FOR UPDATE) opens an implicit transaction when issued?
opens and closes.if you don't bracket with BEGIN;
COMMIT|ROLLBACK;then each statement is a transaction of and by
On Mon, Nov 7, 2011 at 2:47 PM, Michael Musenbrock redea...@gmx.net wrote:
was intentionally looking for a trigger firing on violating of an
already existing constraint.
So am I got that right, that If I want to have eg custom error messages
for a foreign
key violation, I need to replace
On 07/11/11 19:18, Lori Corbani wrote:
I have a function, call it 'functionMain'. And I have several tables that each
have trigger functions. Each trigger function needs to call 'functionMain'
(with different parameters).
table A = trigger function A == functionMain
table B = trigger
On 07/11/11 14:43, Ivan Sergio Borgonovo wrote:
create or replace function test_insert() returns void as
[snip]
$$ language plpgsql volatile;
set search_path to 'test1', 'public';
set search_path to 'test2', 'public';
[snip unexpected behaviour]
I now try to add a SET search_path to
Em 07-11-2011 20:54, John R Pierce escreveu:
On 11/07/11 2:41 PM, Edson Richter wrote:
Does simple SELECT query like
select * from tableX
(without FOR UPDATE) opens an implicit transaction when issued?
opens and closes.if you don't bracket with BEGIN;
COMMIT|ROLLBACK;then
On Mon, Nov 7, 2011 at 3:30 PM, Edson Richter rich...@simkorp.com.br wrote:
Thanks for the fast answer. Is there any way to avoid that? I mean, in MS
SQL Server, I do have with no_lock (that produces dirty reads)?
Or the way to go is the transaction isolation level?
The lowest level of
On 11/07/11 3:30 PM, Edson Richter wrote:
Thanks for the fast answer. Is there any way to avoid that? I mean, in
MS SQL Server, I do have with no_lock (that produces dirty reads)?
Or the way to go is the transaction isolation level?
there's no actual overhead in a single statement read
2011/11/7 Raymond O'Donnell r...@iol.ie:
On 07/11/2011 20:13, pasman pasmański wrote:
Hi.
Is any application, which works as www server on client's side, and
loads pages from postgresql database? (free or commercial)
Many. Depends on what you want to do care to be a bit more specific?
On 11/7/11, Merlin Moncure mmonc...@gmail.com wrote:
On Mon, Nov 7, 2011 at 3:47 PM, Robert James srobertja...@gmail.com wrote:
I've been using a query on Postgres 8.4 with a negative OFFSET, which
works fine:
SELECT DISTINCT s.* FROM s WHERE ... ORDER BY s.bday ASC, s.name
ASC LIMIT 15
On Monday, November 07, 2011 11:27:05 am Cody Caughlan wrote:
I am trying to restore a dump created with pg_dump, both source and
destination are Postgres 9.1.1 albeit different machines (source is Linux,
destination is OS X).
$ pg_restore -U postgres -Fc -d batch_api_production
Hi,friends.
Can you tell me the difference between the dpkg -b directory packagename and
dpkg-buildpackage -rfakeroot.Do these two commands both have the function of
build a debian package?
Hi,
I have simple question (I think which is not easy to answer): why
Postgres is so slow comparing to other Postgres based MPP products
(even on the same box in single node configuration)?
I'm mot talking about multi node setup; all benchmarks were done on
single box (CentOS 5.5, 16 cores, 80GB
Robert James srobertja...@gmail.com writes:
On 11/7/11, Merlin Moncure mmonc...@gmail.com wrote:
On Mon, Nov 7, 2011 at 3:47 PM, Robert James srobertja...@gmail.com wrote:
I've been using a query on Postgres 8.4 with a negative OFFSET, which
works fine:
SELECT DISTINCT s.* FROM s WHERE ...
On 11/08/2011 07:06 AM, Richard Broersma wrote:
I'd be more maintainable to catch these errors in your client
application. Here you would reword these error messages according the
business rules of your client application.
+1
It's not hard to create:
CONSTRAINT some_constraint_name
On 11/08/2011 09:18 AM, daflmx wrote:
Hi,friends.
Can you tell me the difference between the dpkg -b directory
packagename and dpkg-buildpackage -rfakeroot.Do these two commands
both have the function of build a debian package?
First: is this an assignment or something? We've had an unusual
On 11/08/2011 09:28 AM, Ondrej Ivanič wrote:
I have simple question (I think which is not easy to answer): why
Postgres is so slow comparing to other Postgres based MPP products
Which one(s) are you referring to? In what kind of workloads?
Are you talking about Greenplum or similar?
On Tue, Nov 1, 2011 at 5:43 AM, patrick keshishian pkesh...@gmail.com wrote:
On Wed, Oct 26, 2011 at 5:46 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
On Wed, Oct 26, 2011 at 6:09 PM, patrick keshishian pkesh...@gmail.com
wrote:
On Wed, Oct 26, 2011 at 4:49 PM, William E. Moreno A.
Thanks for reply.
I have simple www server.
Today postgres and www server are on single computer. Plan is to
reduce cpu consumption by client application which translate requests
from internet explorer directly to postgres.
2011/11/8, Scott Marlowe scott.marl...@gmail.com:
2011/11/7 Raymond
Hi,
On 8 November 2011 16:58, Craig Ringer ring...@ringerc.id.au wrote:
Which one(s) are you referring to? In what kind of workloads?
Are you talking about Greenplum or similar?
Yes, mainly Geenplum and nCluster (AsterData). I haven't played with
gridSQL and pgpool-II's parallel query mode
On 11/07/11 10:25 PM, pasman pasmański wrote:
Thanks for reply.
I have simple www server.
Today postgres and www server are on single computer. Plan is to
reduce cpu consumption by client application which translate requests
from internet explorer directly to postgres.
that 'client
On 11/07/11 10:49 PM, Ondrej Ivanič wrote:
mostly heavy read
workloads but OLTP performance is required (like run query over 100m+
dataset in 15 sec)
that isn't OLTP, its OLAP. Online Analytic Processing rather than
Online Transaction Processing large complex reporting queries that
On 11/08/2011 02:49 PM, Ondrej Ivanič wrote:
Usually CPU is not bottleneck but I it was when I put Pustgres on
FusionIO. The problem is that PG spreads reads too much . iostat
reports very low drive utilisation and very low queue size.
Spreads reads too much ?
Are you saying there's too much
42 matches
Mail list logo