On Sun, Jul 14, 2013 at 8:36 PM, Vincenzo Romano
vincenzo.rom...@notorand.it wrote:
I am only concerned about how late is done the binding between a table
name and the actual OID for other functions, views and triggers.
Well, it should work like this: once the parser decides that a query
On Sun, Jul 14, 2013 at 10:56 PM, Granthana Biswas
granthana.bis...@gmail.com wrote:
Thank you for your reply. Have you implemented this while sharding your
database? Did it cause any performance issues?
I used it for just several mission critical featured in one project,
not widely. What about
2013/7/15 Luca Ferrari fluca1...@infinito.it:
On Sun, Jul 14, 2013 at 8:36 PM, Vincenzo Romano
vincenzo.rom...@notorand.it wrote:
I am only concerned about how late is done the binding between a table
name and the actual OID for other functions, views and triggers.
Well, it should work
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
On Mon, Jul 15, 2013 at 8:33 AM, Vincenzo Romano
vincenzo.rom...@notorand.it 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
2013/7/15 Luca Ferrari fluca1...@infinito.it:
On Mon, Jul 15, 2013 at 8:33 AM, Vincenzo Romano
vincenzo.rom...@notorand.it 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
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.
Are
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
On Mon, Jul 15, 2013 at 1:45 PM, Baldur Þór Emilsson bal...@baldur.biz 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
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
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
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.
It works with ActivePython 3.2.2.3, but not ActivePython 2.7.2.5.
-- Original --
From: Raghavendraraghavendra@enterprisedb.com;
Date: Jul 11, 2013
To: guxiaobo1982guxiaobo1...@qq.com;
Cc: Jovam...@amutu.com; Michael Paquiermichael.paqu...@gmail.com;
On Mon, Jul 15, 2013 at 6:08 AM, Haiming Zhang haiming.zh...@redflex.com.au
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
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 |
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 gray...@gmail.com wrote:
On Wed, Jul 10, 2013 at 10:20 PM, Granthana Biswas
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
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.
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
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
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 dennis.jenkins...@gmail.com
wrote:
On Fri, Jul 5, 2013 at 8:58 AM, Stuart Ford stuart.f...@glide.uk.comwrote:
On Fri, Jul 5, 2013 at
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]http://user/SendEmail.jtp?type=nodenode=5763678i=0wrote:
Thanks Adrian for your reply. You were
=?gb18030?B?Z3V4aWFvYm8xOTgy?= guxiaobo1...@qq.com 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
23 matches
Mail list logo