On Jan 29, 2009, at 1:35 AM, Phoenix Kiula wrote:
On Thu, Jan 29, 2009 at 2:25 AM, Alban Hertroys
wrote:
Ah I see, that's the original query and its plan again, not the one
after
implementing those triggers! You had me scratching my head for a
bit there,
wondering why the count() subquery
On Tue, 2009-01-27 at 12:53 -0500, Gabi Julien wrote:
> I have merged the last hot standby patch (v9g) to 8.4 devel and I am pleased
> with the experience. This is promising stuff.
Thanks,
> Perhaps it is a bit too soon to
> ask questions here but here it is:
Thanks very much for the bug r
OK, I found another way to send the data using the array format and
"cube($1::float8[])".
Thanks!
Andy.
On Jan 28, 2009, at 2:47 PM, Tom Lane wrote:
There isn't one --- contrib/cube doesn't provide send/receive
functions at all.
regards, tom lane
--
Sent via pgsql
Hi
For the record. Using search_path for schema name handling is most annoying
feature of pg_dump for us. I have run into many cases where separating
schema is inconvenient but don't seem to remember any upsides.
regards
Asko
On Wed, Jan 28, 2009 at 7:39 PM, Tom Lane wrote:
> "Raymond O'Donnel
In response to Josh Harrison :
> Hi
> Is it possible to disable FK constraints in Postgresql?
You can set the constraint deferred (if the constraint defined
deferrable) or drop the constraint.
http://www.postgresql.org/docs/current/static/sql-set-constraints.html
Regards, Andreas
--
Andreas Kr
Bill Todd wrote:
Where can I find documentation for the system tables? I have not found
anything in the 8.3.1 documentation. Thanks.
Bill
Hi Bill,
Good to see a Delphi guy here :-)
http://www.postgresql.org/docs/8.3/interactive/catalogs.html
Later,
Tony Caduto
AM Software Design
http://w
Hi
Is it possible to disable FK constraints in Postgresql?
Thanks
Josh
Bill Todd wrote:
Where can I find documentation for the system tables? I have not found
anything in the 8.3.1 documentation. Thanks.
Bill
http://www.postgresql.org/docs/8.3/static/catalogs.html
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
Where can I find documentation for the system tables? I have not found
anything in the 8.3.1 documentation. Thanks.
Bill
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Jan 29, 2009 at 2:25 AM, Alban Hertroys
wrote:
> Ah I see, that's the original query and its plan again, not the one after
> implementing those triggers! You had me scratching my head for a bit there,
> wondering why the count() subquery was still there.
Yes that was just for info. He
On Wednesday 28 January 2009 18:35:18 Gabi Julien wrote:
> On Tuesday 27 January 2009 21:47:36 you wrote:
> > Hi,
> >
> > On Wed, Jan 28, 2009 at 4:28 AM, Gabi Julien
>
> wrote:
> > > Yes, the logs are shipped every minute but the recevory is 3 or 4 times
> > > longer.
> >
> > Are you disabling fu
On Tuesday 27 January 2009 21:47:36 you wrote:
> Hi,
>
> On Wed, Jan 28, 2009 at 4:28 AM, Gabi Julien
wrote:
> > Yes, the logs are shipped every minute but the recevory is 3 or 4 times
> > longer.
>
> Are you disabling full_page_writes? It may slow down recovery several
> times.
It looks like yo
aws writes:
> I'm using libpq with a prepared query, and I'd like to access the
> contrib/cube type using the binary format. The documentation
> describes the text format for cubes but doesn't say what the binary
> format is.
There isn't one --- contrib/cube doesn't provide send/receive
fu
I'm using libpq with a prepared query, and I'd like to access the
contrib/cube type using the binary format. The documentation
describes the text format for cubes but doesn't say what the binary
format is.
I glanced at the source code but... its complicated. :) Any help is
appreciated.
On Wed, 28 Jan 2009, Ivan Sergio Borgonovo wrote:
On Tue, 27 Jan 2009 20:45:53 +0300
Teodor Sigaev wrote:
No matter if I drop the trigger that update agg content and the
fact that I'm just updating d, postgresql will update the index?
Yes, due to MVCC. Update of row could produce new version
On Tue, 27 Jan 2009 20:45:53 +0300
Teodor Sigaev wrote:
> > No matter if I drop the trigger that update agg content and the
> > fact that I'm just updating d, postgresql will update the index?
> Yes, due to MVCC. Update of row could produce new version (tuple)
> and new version should be index as
On Tuesday 27 January 2009 16:25:44 you wrote:
> On Tue, 2009-01-27 at 14:28 -0500, Gabi Julien wrote:
> > Could this help? If the logs are smaller then I could potentially afford
> > shipping then at a higher frequency.
>
> See if there are times during which the recovery process isn't doing
> any
On Jan 28, 2009, at 1:38 PM, Phoenix Kiula wrote:
Thanks Alban. We have now made all the triggers and such. That part is
working. I suppose not having the count(id) is helping just with a few
seconds, but the query is still taking about 15 seconds in some cases.
Here are the query and its exec
"Raymond O'Donnell" writes:
> On 28/01/2009 17:09, David Miller wrote:
>> Pg Dump does not include schema name on insert statement generated
>> from pg_dump with a -d option when exporting data for a particular
>> table using the -t . in version 8.3. I believe this
>> same bug exists in 8.4 but ha
On Wed, 2009-01-28 at 09:09 -0800, David Miller wrote:
> Pg Dump does not include schema name on insert statement generated from
> pg_dump with a -d option when exporting data for a particular table using the
> -t . in version 8.3. I believe this same bug exists in 8.4 but
> have not confirmed i
On 28/01/2009 17:09, David Miller wrote:
> Pg Dump does not include schema name on insert statement generated
> from pg_dump with a -d option when exporting data for a particular
> table using the -t . in version 8.3. I believe this
> same bug exists in 8.4 but have not confirmed it. I believe pg_d
Pg Dump does not include schema name on insert statement generated from pg_dump
with a -d option when exporting data for a particular table using the -t
. in version 8.3. I believe this same bug exists in 8.4 but have
not confirmed it. I believe pg_dump should have an option to retain schema
in
On Tue, Jan 27, 2009 at 5:49 PM, Noel Proffitt wrote:
> I'm available to volunteer for a couple of hours or so. Let me know what time
> slots you're looking to cover.
Thanks Noel. The schedule will be pretty flexible. Any times between
Saturday and Sunday will be fine.
--
Regards,
Richard B
Hi,
On Thu, Jan 29, 2009 at 12:23 AM, Jason Long
wrote:
> Is pg_clearxlogtail going to be in contrib or integrated in some other way?
I also hope so. The related topic was discussed before.
http://archives.postgresql.org/pgsql-hackers/2009-01/msg00639.php
Regards,
--
Fujii Masao
NIPPON TELEGR
Fujii Masao wrote:
Hi,
On Wed, Jan 28, 2009 at 4:28 AM, Gabi Julien wrote:
Yes, the logs are shipped every minute but the recevory is 3 or 4 times
longer.
Are you disabling full_page_writes? It may slow down recovery several times.
Thanks I will take a look at it. Also, I came a
Phoenix Kiula writes:
> My question: with that kind of volume and the underlying aggregation
> functions (by product id, dates, possibly IP addresses or at least
> countries of origin..) will PG ever be a good choice?
Well, only you're able to judge that for your own data and use cases.
Your q
Hi. Further to my bafflement with the "count(*)" queries as described
in this thread:
http://archives.postgresql.org/pgsql-general/2009-01/msg00804.php
It seems that whenever this question has come up, Postgresql comes up
very short in terms of "count(*)" functions.
The performance is always slo
On Wed, Jan 28, 2009 at 2:37 AM, Alban Hertroys
wrote:
>
> Does that query plan look any better without the select count(id) from
> testimonials?
>
> If so you may be better off keeping track of those counts in a separate
> table updated by triggers on the testimonials table. Whether that really
>
Greetings everyone, I'm new to this list (No, I'm not about to ask how to
install pgsql on Windows 3.11!)
We are involved with a financial project, similar to Paypal (Web Payments
Standard/Payment Buttons) but the scope and functionality is much narrower. This
project will be released in a market
Hi,
I added an index on a Postgresql 7.4 database this morning (about 50
concurrent users), and then deleted it. I noticed the delete took too
much time to complete, so I logged on the server, and did a "ps -afxu".
I saw a process was stuck in a "drop index waiting" state, and several
others in a
2009/1/28 fatih arıkan :
> Hi all,
>
> I want to make an installer like postgresql-8.3.msi and
> postgresql-8.3-int.msi. I want after one msi runs, another msi will run. I
> want to ask where can I find sources of these msi installers. I have
> found postgresql-8.3-int.msi wix sources but I couldn'
On 1/28/09, Hermann Muster wrote:
> When creating a view via DBLINK, the user=... and password=... parameters
> shall be optional. If they are left out, then the current user accessing the
> view shall be impersonated implicitely to the "dblinked" database as well.
> Forcing anybody to hardcode a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Abdul Rahman wrote:
> Very nice!
> Most probably it was waiting for something else. This is the reason the
> query executed today and clearly showed certain number of rows deleted.
> But what ELSE?
>
It could be a ton of things, but as an example, if
When creating a view via DBLINK, the user=... and password=...
parameters shall be optional. If they are left out, then the current
user accessing the view shall be impersonated implicitely to the
"dblinked" database as well. Forcing anybody to hardcode a password
readable within the view defin
Well Jaime,
I executed all the delete queries one by one. Now I am unable to understand
that why it took sufficient time to run the last query before cancellation.
i.e. delete from ci_cif_v where req_id='0824100207';
This morning it performed the delete operation and deleted certain number of
Hi all, I want to make an installer like postgresql-8.3.msi and
postgresql-8.3-int.msi. I want after one msi runs, another msi will run. I want
to ask where can I find sources of these msi installers. I have found
postgresql-8.3-int.msi wix sources but I couldn't find postgresql-8.3.msi
source
36 matches
Mail list logo
