Hi all,
I have 1 table have:
- 417 columns
- 600.000 rows data
- 34 indexs
when i use query on this table, it so long. ex:
update master_items set
temp1 = '' where temp1 <> '' --Query returned successfully: 435214 rows
affected, 1016137 ms execution time.
alter table master_items add "TYPE-DE"
Is there a way to reload shared_preload_libraries with out restarting the
server??
I tried alter system command in postgres 9.4 but I could not change it..
On Wed, Mar 25, 2015 at 7:03 PM, Sreerama Manoj
wrote:
> Is there a way to reload shared_preload_libraries with out restarting the
> server??
>
> I tried alter system command in postgres 9.4 but I could not change it..
Server needs to be restarted, there is no other way to have its new
value take
Hi all,
I'm creating a table from a select query. During the execution it errors
with:
ERROR: could not read block 13 of temporary file: Success
I am running Postgresql 9.1 on a Debian/Linux server.
Does anyone have any suggestions on what could be causing this?
I checked diskspace and permis
Hi,
Traditionally it hadn't made much sense to fire a trigger on a receiving
replica node (slave) - for many reasons, including it being read-only.
But with BDRs multi parter, partial replication and the possibility that
some tables are either actually or logically local to a single node,
th
On 25 March 2015 at 19:15, Peter Mogensen wrote:
> Hi,
>
> Traditionally it hadn't made much sense to fire a trigger on a receiving
> replica node (slave) - for many reasons, including it being read-only.
>
> But with BDRs multi parter, partial replication and the possibility that
> some tables a
On Wed, Mar 25, 2015 at 4:19 AM, ginkgo36 wrote:
> Hi all,
> I have 1 table have:
> - 417 columns
> - 600.000 rows data
> - 34 indexs
>
> when i use query on this table, it so long. ex:
>
> update master_items set
> temp1 = '' where temp1 <> '' --Query returned successfully: 435214 rows
> affected
On 2015-03-25 12:32, Craig Ringer wrote:
On 25 March 2015 at 19:15, Peter Mogensen wrote:
Say ... I have a table in a BDR replicated database with an "ON UPDATE"
trigger. - and that trigger wants to locally find out the local
txid_snapshot_xmin() when a change was applied to the local node.
I'm not an expert either, but your data model sounds very broken as
well... I guess it's possible that each query would need all 417 columns
but it seems unlikely...
If that were normalized into 'n' tables then each query would be returning
a whole lot less data...
I've never heard of a database
Hi all
For BDR users here, I'd just like to let you know that the RPM repository
will shortly contain BDR 0.9.0 packages as well as the existing 0.8.0 RPMs.
This means that if you "yum upgrade", or do a "yum install" without
specifying a version, you'll get the pending release.
If you want to en
On 03/25/2015 03:50 AM, Rebecca Clarke wrote:
Hi all,
I'm creating a table from a select query. During the execution it errors
with:
ERROR: could not read block 13 of temporary file: Success
That is a mixed message.
Did the create table succeed?
Does it always happen?
Could you show the c
@Gary
I'm working on big data, because of the demands of the job so I
export/import/update data on this table every day.
I guess it's possible that each query would need all 417 columns but it
seems unlikely... --> Yes, not at all but 2/3 of 417 columns :)
I need gather data into one table for
If the user is given the necessary rights, then can the connection process get
a context of the user?
Is there the possibility in principle?
24.03.2015, 21:11, "John R Pierce" :
> On 3/24/2015 5:16 AM, Мартынов Александр wrote:
>> There is postgres db with sepgsql enabled. When user connect
On 25/03/2015 14:30, ginkgo36 wrote:
> @Gary
> I'm working on big data, because of the demands of the job so I
> export/import/update data on this table every day.
>
> I guess it's possible that each query would need all 417 columns but it
> seems unlikely... --> Yes, not at all but 2/3 of 417 c
Hi.
I have question regarding release of postgresql 9.5 - Are we expecting it
to be released in Sept 2015?
1) Since Postgresql 9.4 was released last year in Dec 2014 instead of Sept
2014, Just wanted to confirm as we would like to plan our upgrade project
based on the release date.
2) Can w
On 03/25/2015 07:30 AM, ginkgo36 wrote:
@Gary
I'm working on big data, because of the demands of the job so I
export/import/update data on this table every day.
I guess it's possible that each query would need all 417 columns but it
seems unlikely... --> Yes, not at all but 2/3 of 417 columns
On 03/25/2015 07:36 AM, yba...@symcor.com wrote:
Hi.
I have question regarding release of postgresql 9.5 - Are we expecting
it to be released in Sept 2015?
1) Since Postgresql 9.4 was released last year in Dec 2014 instead of
Sept 2014, Just wanted to confirm as we would like to plan our upgrad
"I need gather data into one table for consistency and easy for export and
import, it's ok if I split data to smaller tables, but when
export/import/update, i must excute query on alot of table. And this way
lead data to inconsistency if I forget update/export/import on 1 or more
table. It is terri
Well, I hope it is of at least a bit of interest to others.
http://newsoffice.mit.edu/2015/michael-stonebraker-wins-turing-award-0325
...
In his previous work at the University of California at Berkeley,
Stonebraker developed two of his most influential systems, Ingres and
Postgres, which provid
On 3/25/2015 2:19 AM, ginkgo36 wrote:
Hi all,
I have 1 table have:
- 417 columns
- 600.000 rows data
- 34 indexs
when i use query on this table, it so long. ex:
update master_items set
temp1 = '' where temp1 <> '' --Query returned successfully: 435214 rows
affected, 1016137 ms execution time.
I'm trying to test BDR 0.9.0 with Postgres 9.4.1-2, both from the 2nd Quadrant
repo. I'm following the latest docs here:
http://bdr-project.org/docs/next/index.html
I started with fresh installations of Postgres and the BDR plugin and have done
something similar to what is shown in the Quick St
On 26 March 2015 at 06:02, Steve Boyle wrote:
> postgres=# SELECT bdr.bdr_group_create(
> postgres(# local_node_name := 'cxtlabdev014',
> postgres(# node_external_dsn := 'port=5432 dbname=prod'
> postgres(# );
> ERROR: getting remote node id failed
> DETAIL: SELECT sysid, timeline,
On 25 March 2015 at 20:14, Peter Mogensen wrote:
>
>
> On 2015-03-25 12:32, Craig Ringer wrote:
>
>> On 25 March 2015 at 19:15, Peter Mogensen wrote:
>>
>> Say ... I have a table in a BDR replicated database with an "ON UPDATE"
>>> trigger. - and that trigger wants to locally find out the local
Alright everyone, this is a doozy of a problem. I am new to Postgres so I
appreciate patience/understanding. I have a database of hardware objects, each
of which has several different "channels". Once per day, these channels are
supposed to check in with a central server, generating an event log
On 03/25/2015 05:25 PM, Lavrenz, Steven M wrote:
Alright everyone, this is a doozy of a problem. I am new to Postgres so
I appreciate patience/understanding. I have a database of hardware
objects, each of which has several different “channels”. Once per day,
these channels are supposed to check i
On Wed, Mar 25, 2015 at 5:25 PM, Lavrenz, Steven M
wrote:
> Alright everyone, this is a doozy of a problem. I am new to Postgres so
> I appreciate patience/understanding. I have a database of hardware objects,
> each of which has several different “channels”. Once per day, these
> channels are s
Correcting the subject
From: Mitu Verma
Sent: March 26, 2015 9:28 AM
To: pgsql-general@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: RE: [GENERAL] Populating missing dates in postgresql data
Hi,
We have a customer complaining about the time taken by one of the application
scripts whi
Hi,
We have a customer complaining about the time taken by one of the application
scripts while deleting older data from the log tables.
During the deletion, customer reported that he often sees the below error and
because of which table size doesn’t reduce.
ERROR: canceling autovacuum task
Dat
On Wed, Mar 25, 2015 at 8:57 PM, Mitu Verma wrote:
> Hi,
>
>
>
> We have a customer complaining about the time taken by one of the
> application scripts while deleting older data from the log tables.
>
> During the deletion, customer reported that he often sees the below error
> and because of w
On Wed, Mar 25, 2015 at 8:58 PM, Mitu Verma wrote:
> Correcting the subject
>
And this is why it is considered good form to do "compose new message"
instead of replying to an existing one. Injecting your new topic into an
existing unrelated mail thread is mildly annoying.
David J.
30 matches
Mail list logo
