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) 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).
>
> Please help m
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() retu
On Thu, Nov 3, 2011 at 11:56 PM, Michael Musenbrock 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.
http://www.postgresql.org/docs/9
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)
becaus
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 :
> Hello
> I've been looking for ways to optimize a query.
>
> I ha
2011/11/7 Ivan Sergio Borgonovo :
> On Mon, 7 Nov 2011 17:55:11 +0100
> Pavel Stehule 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 same problem.
>
> Do different us
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:
http://postgresql.1045698.n5.nabble.com/installation-problems-on-O
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 => trigg
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: http://www.ent
Hello
2011/11/7 Lori Corbani :
>
> 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
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:
http://www.postgresql.org/mailpr
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 ch
On Mon, Nov 7, 2011 at 3:47 PM, Robert James 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 get an error:
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] unexpecte
On Mon, 7 Nov 2011 19:07:29 +0100
Pavel Stehule wrote:
> 2011/11/7 Ivan Sergio Borgonovo :
> > On Mon, 7 Nov 2011 17:55:11 +0100
> > Pavel Stehule wrote:
> >
> >> Hello
> >>
> >> this is know bug/feature based on caching plans
> >
> > What puzzled me is I'm operating in a similar way in a differ
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 :: Galw
Does simple SELECT query like
select * from tableX
(without FOR UPDATE) opens an implicit transaction when issued?
Thanks,
--
Edson Carlos Ericksson Richter
Si
Am 2011-11-07 16:06, schrieb Richard Broersma:
> On Thu, Nov 3, 2011 at 11:56 PM, Michael Musenbrock 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 "CO
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 itself
On Mon, Nov 7, 2011 at 2:47 PM, Michael Musenbrock 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 all fkeys by
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 the
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 ea
On Mon, Nov 7, 2011 at 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?
The lowest level of Isolation supported by Po
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 trans
2011/11/7 Raymond O'Donnell :
> 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 wrote:
> On Mon, Nov 7, 2011 at 3:47 PM, Robert James 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
>>
>
> the original b
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
> 20
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 writes:
> On 11/7/11, Merlin Moncure wrote:
>> On Mon, Nov 7, 2011 at 3:47 PM, Robert James 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 -
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 FOREIG
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?
Another
On Tue, Nov 1, 2011 at 5:43 AM, patrick keshishian wrote:
> On Wed, Oct 26, 2011 at 5:46 PM, Scott Marlowe
> wrote:
>> On Wed, Oct 26, 2011 at 6:09 PM, patrick keshishian
>> wrote:
>>> On Wed, Oct 26, 2011 at 4:49 PM, William E. Moreno A.
>>> wrote:
Solution: http://archives.postgresql.o
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 :
> 2011/11/7 Raymond O'Donnell :
>> On 07/11
Hi,
On 8 November 2011 16:58, Craig Ringer 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 too much. Queries are
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 applicat
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
h
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 muc
42 matches
Mail list logo
