> Hmmm ... why is the inner Nested Loop estimated to produce
> 30120 rows,
> when the cartesian product of its inputs would only be 285
> * 14 = 3990
> rows?
Oh my... didn't notice it!!!
> What PG version is this
That was 8.4 beta1; now tried on
select version()
"PostgreSQL 8.4.0 on sparc-s
alter table profile_projectexp drop key
profile_projectexp_person_id_6fe12f6f;
I think that this syntax is specific to mysql. can someone translate?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgs
Scara Maccai wrote:
Hmmm ... why is the inner Nested Loop estimated to produce
30120 rows,
when the cartesian product of its inputs would only be 285
* 14 = 3990
rows?
Oh my... didn't notice it!!!
It was doing the same thing here too:
http://explain-analyze.info/query_plans/3807-query-pla
Query:
set enable_mergejoin=off;set enable_hashjoin=off;
explain analyze
select nome1,
thv3tralacc,
dltbfpgpdch
FROM cell_bsc_60_0610 as cell_bsc
left outer join teststscell73_test as data on
data.ne_id=cell_bsc.nome1
left outer
In response to Skylar Saveland :
> alter table profile_projectexp drop key
> profile_projectexp_person_id_6fe12f6f;
>
> I think that this syntax is specific to mysql. can someone translate?
What do you want to achieve? DROP the Primary Key?
ALTER TABLE profile_projectexp DROP CONSTRAINT ;
For
Skylar Saveland wrote:
alter table profile_projectexp drop key
profile_projectexp_person_id_6fe12f6f;
I think that this syntax is specific to mysql. can someone translate?
drop index profile_projectexp_person_id_6fe12f6f;
--
Postgresql & php tutorials
http://www.designmagick.com/
--
Sent v
Albe Laurenz [2009-08-14 07:34]:
> Radoslaw Zielinski wrote:
[...]
>> The "orphans" count should be 0, obviously.
> Just to make sure that there is really an inconsistency:
> Could you pg_dump both tables and try to load them into
> another database? If that works without errors, we must have
> m
On 2009-08-09, Mindaugas G. wrote:
> Hi,
>
> googling few days with no success,
> for example I have db with ip_src etc ant its data type bigint,
> how must look select query what I can see ip address (int) instead of
> bigint?
dunno if this will help.
create function bigint_to_inet(bigint) re
Hello,
it seems that I should reduce the Fill Factor of some FTS indexes, but
what is the default ?
The doc days:
> The other index methods use fillfactor in different but roughly
analogous ways;
> the default fillfactor varies between methods
Thanks,
Marc Mamin
On 2009-08-04, Paul Taylor wrote:
> Bill Moran wrote:
>> In response to Paul Taylor :
>>
>>
>>> Bill Moran wrote:
>>>
In response to Paul Taylor :
> Sam Mason wrote:
>
>
>> On Tue, Aug 04, 2009 at 01:37:34PM +0100, Paul Taylor wrote:
On 2009-08-05, Paul Taylor wrote:
> Sam Mason wrote:
>> On Wed, Aug 05, 2009 at 08:02:13AM -0400, Bill Moran wrote:
>>
>>> In response to Paul Taylor :
>>>
this
is an opensource project and to enable others to contribute easily it is
much easier if they can download the co
On 2009-08-12, Jim Michaels wrote:
> --0-1559521671-1250064688=:25681
> Content-Type: text/plain; charset=us-ascii
>
> I am struggling to learn libpq.
>
> for some reason, I could not get an INSERT to produce an Oid. actually, what
> I am looking for, is to get the ID of the last record inserted
Friends of pgsql-general list,
I have a problem: I need put the "table name" as a parameter in a function!
So, When I write, inside that function, the following code:
SELECT INTO var_resposta SUM(campo) FROM $1
return var_resposta;
Knows that $1 is the table name, the postgres said that this is
Hi all,
in the docs I read:
"Adding a column with a non-null default [...] will require the entire table to
be rewritten"
I guess that that can't be read as "you can always assume that adding a
nullable column to a table won't rewrite the whole table".
I'm asking because since the page layout
> I have a problem: I need put the "table name" as
> a parameter in a function!
I think you have to use dynamic statements:
http://www.postgresql.org/docs/8.4/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.o
look at EXECUTE in plpgpsql.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi all,
I have been watching this field (index_size) , and see probable bug on size .
anybody may explain me how fix it?
select * from pgstatindex('micromedicao.xfk8_consumo_historico');
version | tree_level | index_size | root_block_no | internal_pages |
leaf_pages | empty_pages | del
On Fri, Aug 14, 2009 at 12:37:14PM +, Scara Maccai wrote:
> I'm asking because since the page layout includes a null bitmap that
> "If it is present it begins just after the fixed header and occupies
> enough bytes to have one bit per data column", I guess that when all
> the bits in the bitmap
2009/8/13 :
> I am working on cleaning up a bloated database. I have been reindexing etc.
> There appear to be a good number of never to almost never used indexes. I
> am looking in pg_stat_user_indexes which yields some questions.
>
> Assuming that the reset stats on server is not turned on ho
paulo matadr writes:
> I have been watching this field (index_size) , and see probable bug on size
> .
> anybody may explain me how fix it?
Switch to 8.4, where the field is properly declared as bigint.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql
> are null.
> But there's also a number saying how many columns there are
Uh, thank you.
Looking for t_natts I think I've found the discussion:
http://archives.free.net.ph/message/20090521.144512.3ffe4801.en.html
Thank you again.
--
Sent via pgsql-general mailing list (pgsql-general@postg
it seems that I should reduce the Fill Factor of some FTS indexes, but
what is the default ?
> The other index methods use fillfactor in different but roughly
analogous ways;
> the default fillfactor varies between methods
Actually, GIN doesn't use it.
--
Teodor Sigaev
On Fri, Aug 14, 2009 at 09:52:02AM +0800, Ow Mun Heng wrote:
> Christophe Pettus wrote:
> >On Aug 11, 2009, at 12:19 AM, Jan Verheyden wrote:
> >> I was looking in what way it's possible to alert via mail when some
> >> conditions are true in a database.
>
> >An external script that connects to
Hello, Guys! Is that kind of thing possible at all? We have a problem that our
database is corrupted, and we are not able to get any table data by executing
SQL requests/running the PG_Admin tool. So, we thought, maybe it is possible to
retrieve data by accessing the data storage directly. The d
Tom Lane-2 wrote:
>
> Neil Best writes:
>> On Fri, Aug 7, 2009 at 12:33 PM, Tom Lane wrote:
>>> BTW, the "SSL renegotiation failure" bit
>>> suggests that it could have been an OpenSSL bug not a real network
>>> lossage, so you might want to see how up-to-date your openssl libraries
>>> are.
>
Hi,
>
> Hello, Guys! Is that kind of thing possible at all? We have a problem that
> our database is corrupted, and we are not able to get any table data by
> executing SQL requests/running the PG_Admin tool. So, we thought, maybe it
> is possible to retrieve data by accessing the data storage dir
On Fri, Aug 14, 2009 at 4:31 PM, Ewgenij Sokolovski wrote:
> Hello, Guys! Is that kind of thing possible at all? We have a problem that
> our database is corrupted, and we are not able to get any table data by
> executing SQL requests/running the PG_Admin tool. So, we thought, maybe it is
> poss
Tom Lane-2 wrote:
>
> Neil Best writes:
>> On Fri, Aug 7, 2009 at 12:33 PM, Tom Lane wrote:
>>> BTW, the "SSL renegotiation failure" bit
>>> suggests that it could have been an OpenSSL bug not a real network
>>> lossage, so you might want to see how up-to-date your openssl libraries
>>> are.
>
Hi all.
I wrote a function and it does not work properly. What am I doing wrong?
*- Here is the script .
---
CREATE OR REPLACE FUNCTION "public"."cxp_balfactura" (x_codcia char, x_suplidor
char, x_factura char, x_monto numeric, x_moneda integer) RETURNS numeric AS
$body$
DECLARE
cursor1
Hi list!
I'm searching for something to use as a proxy for different instances of
postgres.
I've found pl/proxy, but it seems to work with (correct me if i'm wrong)
functions, and some hard work would be needed in our applications in
order to make them use those functions replacing direct access
> I'm searching for something to use as a proxy for different instances of
> postgres.
>
> I've found pl/proxy, but it seems to work with (correct me if i'm wrong)
> functions, and some hard work would be needed in our applications in
> order to make them use those functions replacing direct access
Have you tried sql relay? They support may platforms:
http://sqlrelay.sourceforge.net/
-Said
Martin Spinassi wrote:
Hi list!
I'm searching for something to use as a proxy for different instances of
postgres.
I've found pl/proxy, but it seems to work with (correct me if i'm wrong)
functio
Martin Spinassi wrote:
I'm searching for something to use as a proxy for different instances of
postgres.
...
So the question is, what can I use as a proxy queries to different
instances of postgres?
perhaps if you better defined what you mean by 'proxy queries'... a
'proxy' is simply somet
On 14 Aug 2009, at 18:42, Ing. Eris J. Gómez wrote:
Hi all.
I wrote a function and it does not work properly. What am I doing
wrong?
*- Here is the script ..
---
CREATE OR REPLACE FUNCTION "public"."cxp_balfactura" (x_codcia char,
x_suplidor char, x_factura char, x_monto numeric, x_moneda
On Fri, 2009-08-14 at 10:03 -0700, John R Pierce wrote:
> Martin Spinassi wrote:
> > I'm searching for something to use as a proxy for different instances of
> > postgres.
> > ...
> > So the question is, what can I use as a proxy queries to different
> > instances of postgres?
> >
>
> perhaps i
Basically, what I'm searching for is something that relay sql to others
postgres instances.
The main goal is to have this proxy balancing, and better if it can
figure out when a postgres server is down. It would give me better
performance and will help mitigating the single point of failure, as
Neil Best writes:
> Tom Lane-2 wrote:
>> You're talking like you've found this to be repeatable. Is it?
> It is indeed repeatable, Tom. I was able to perform my \copy batch job
> multiple times without error by working over the local connection. I had to
> run it many times to iteratively catc
On Fri, 2009-08-14 at 11:04 -0700, John R Pierce wrote:
> Martin Spinassi wrote:
> > I've been playing around with slony, and as far it didn't make me jump
> > of happiness, I think is my better option to use slony for that,
> > updating just the master, let slony do his job, but allowing the proxy
Tom Lane-2 wrote:
>
> Sorry, I meant to ask whether the *failure* was repeatable.
>
Oh, I see. Well, to the extent that i had the same problem in two different
remote clients before finding that the local connection work-around made it
go away, I would say that it was repeatable. In short,
Martin Spinassi wrote:
So, what you suggest is:
|-> Master <---|
pg_pool2 ---||- Slony
|-> Slave<---|
Can't figure out if this is gonna work, configuring pg_pool2 to read
both, making slony replicate, and app directly to
On Fri, Aug 14, 2009 at 06:10:17AM -0700, paulo matadr wrote:
> I have been watching this field (index_size) , and see probable bug on size
> .
> anybody may explain me how fix it?
> select * from pgstatindex('micromedicao.xfk8_consumo_historico');
> version | tree_level | index_size |
On Fri, 2009-08-14 at 11:36 -0700, John R Pierce wrote:
> Martin Spinassi wrote:
> > So, what you suggest is:
> >
> > |-> Master <---|
> > pg_pool2 ---||- Slony
> > |-> Slave<---|
> >
> >
> > Can't figure out if this is gonna
I wrote a postgres embedded application that uses libpq and requires the
postgres DLL's in the bin directory to run. I am curious if I am allowed to
package my app with the DLL's without distributing the entire postgres database
application, though I could include all of postgres.
postgres is u
Jim Michaels wrote:
> I wrote a postgres embedded application that uses libpq and requires
> the postgres DLL's in the bin directory to run. I am curious if I am
> allowed to package my app with the DLL's without distributing the
> entire postgres database application, though I could include all of
44 matches
Mail list logo
