Reply: Reply: [GENERAL] Can we specify transaction level when connectting toexternal postgresql server via postgres_fdw

Greeplum is based on 8.2.15, so we can only use the read-only option. -- Original -- Sender: "Tom Lane"; Send time: Tuesday, Jul 16, 2013 1:57 PM To: "guxiaobo1982"; Cc: "Jov"; "pgsql-general"; Subject: Re: Reply: [GENERAL] Can we specify transaction level when

Re: Reply: [GENERAL] Can we specify transaction level when connectting toexternal postgresql server via postgres_fdw

"=?gb18030?B?Z3V4aWFvYm8xOTgy?=" writes: > It works for insert and select statement under serializable level, but it > seems update/delete statements are not support, is that true? > template1=# update user_info set info='1234' where id=102; > ERROR: DECLARE CURSOR ... FOR UPDATE/SHARE is not su

[GENERAL] Re: pg_upgrade could not create catalog dump while upgrading from 9.0 to 9.2

Thank You Adrian for your information. On Sun, Jul 14, 2013 at 12:13 AM, Adrian Klaver-3 [via PostgreSQL] < ml-node+s1045698n5763678...@n5.nabble.com> wrote: > On 07/12/2013 11:25 PM, [hidden > email]wrote: > > Thanks Adrian for your reply.

Re: [GENERAL] "soft lockup" in kernel

Stuart, I'm simply curious - did you resolve your issue? What NAS (vendor/model/config) are you using? On Fri, Jul 5, 2013 at 11:31 AM, Dennis Jenkins wrote: > > On Fri, Jul 5, 2013 at 8:58 AM, Stuart Ford wrote: > >> On Fri, Jul 5, 2013 at 7:00 AM, Dennis Jenkins wrpte >> > > >> No. iSCSI

Re: [GENERAL] Build RPM from Postgres Source

On Fri, Jul 12, 2013 at 02:37:19PM -0700, ktewari1 wrote: - Hi, - I need to have some different settings(like NAMEDATALEN etc.) and - that's why I'm trying to build postgres from the source and to create an rpm - to be send for install. - - Now, the build works fine but, I don't see a way to

Re: [GENERAL] V8.4 TOAST table problem

David, I'm sorry, but I'm not sure that I follow how this is pertinent to this particular thread. Are you proposing a way to replicate the scenario we experienced of our massively bloated TOAST table? If so, I'm not entirely sure that's doable given that the source of the issue was never clear.

Re: [GENERAL] V8.4 TOAST table problem

Thanks, Scott. Currently, it's a bit difficult due to resources for a complete copy of the database to be useful. I won't get into the details, but it just wasn't an option at the time. With that said, I'm definitely making it a major concern of ours for such future issues, so post mortem and su

Re: [GENERAL] last_vacuum field is not updating

Hi Al, Il 15/07/2013 16:58, AI Rumman ha scritto: Why does vacuum table is not updating the field last_vacuum of pg_stat_user_tables? To vacuum a table, one must ordinarily be the table's owner. However, database owners are allowed to vacuum all tables in their databases. VACUUM will skip ove

Re: [GENERAL] Transaction control in shards through PLPROXY

Hi Sergey, Thank you for your reply. Have you implemented this while sharding your database? Did it cause any performance issues? Warm regards, GB On Mon, Jul 15, 2013 at 10:51 AM, Sergey Konoplev wrote: > On Wed, Jul 10, 2013 at 10:20 PM, Granthana Biswas > wrote: > > Inspite of being aware

[GENERAL] last_vacuum field is not updating

Why does vacuum table is not updating the field last_vacuum of pg_stat_user_tables? select * from pg_stat_user_tables where relname = 'table1'; -[ RECORD 1 ]-+-- relid | 5452445 schemaname| public relname | table1 seq_scan | 5

Re: [GENERAL] Update big table

On Mon, Jul 15, 2013 at 6:08 AM, Haiming Zhang wrote: > I run my query using JOIN for two hours, and did not get it done. Here is > my query: > > update table1 set col1 = true from table2 where table1.event_id = > table2.event_id > Did you already post the query plan from "EXPLAIN update table1

[GENERAL] Re: Reply: [GENERAL] ?????? [GENERAL] Can't create plpython language

It works with ActivePython 3.2.2.3, but not ActivePython 2.7.2.5. -- Original -- From: "Raghavendra"; Date: Jul 11, 2013 To: "guxiaobo1982"; Cc: "Jov"; "Michael Paquier"; "pgsql-general"; "Asif Naeem"; Subject: Re: Reply: [GENERAL] ?? [GENERAL] Can't

Reply: [GENERAL] Can we specify transaction level when connectting toexternal postgresql server via postgres_fdw

It works for insert and select statement under serializable level, but it seems update/delete statements are not support, is that true? template1=# update user_info set info='1234' where id=102; ERROR: DECLARE CURSOR ... FOR UPDATE/SHARE is not supported DETAIL: Cursors must be READ ONLY. CONT

Re: [GENERAL] Read data from WAL

Thank you all for your responses. I'm aware of xlogdump but I'm afraid it does not help me with readign the data in the WAL. It is mainly "for debugging or educational purposes" (citing the docs) and it outputs a lot of information about the WAL records but not the contents of them (e.g. it says wh

Re: [GENERAL] Update big table

Hi, Thanks for your reply. Yes you are right, IN predicate is the cause but the JOIN does not help much. I run my query using JOIN for two hours, and did not get it done. Here is my query: update table1 set col1 = true from table2 where table1.event_id = table2.event_id Regards, Haiming

Re: [GENERAL] Read data from WAL

On Mon, Jul 15, 2013 at 1:45 PM, Baldur Þór Emilsson wrote: > Are there any projects or standard procedures for reading the data from the > WAL to get a change log for the database (or without the WAL, using some > other method)? I have searched for information about this quite thoroughly > withou

Re: [GENERAL] Read data from WAL

Hi, 2013/07/15 21:45, Baldur Þór Emilsson wrote: Are there any projects or standard procedures for reading the data from the WAL to get a change log for the database (or without the WAL, using some other method)? I have searched for information about this quite thoroughly without luck, so I thou

[GENERAL] Read data from WAL

I have been looking into the WAL to know if there is any way to read the data contained in it. I know that it stores binary data that is applied directly to the files in the Postgres cluster. I would like to get the "real" data, like it is written in the SQL queries, instead of the binary data. Ar

Re: [GENERAL]

2013/7/15 Luca Ferrari : > On Mon, Jul 15, 2013 at 8:33 AM, Vincenzo Romano > wrote: > >> The alternative is to do things the "good ol' way" by DELETING+INSERTING >> (http://tapoueh.org/blog/2013/07/05-archiving-data-fast.html) >> Where I'd fear for longer LOCKs. > > > I don't know if this is an o

Re: [GENERAL]

On Mon, Jul 15, 2013 at 8:33 AM, Vincenzo Romano wrote: > The alternative is to do things the "good ol' way" by DELETING+INSERTING > (http://tapoueh.org/blog/2013/07/05-archiving-data-fast.html) > Where I'd fear for longer LOCKs. I don't know if this is an option for your case study, but you co

Re: [GENERAL] V8.4 TOAST table problem

Hi, I think I could write a script to do something similar to what is happening if anyone is interested. I'd want some direction as to the best way to handle this though: it'd be easier for me to script it as Rails code because that's what the app is. Perhaps from that we can get the generated S