Hi there,
Le mercredi 04 septembre 2013 à 14:04 -0700, Richard Sickler a écrit :
> How about an elephant flying around Earth.
> Caption: PostgreSQL - Used all around the World
Why not, but I has to be at least at an orbital altitude, since
PostgreSQL is also used by some space companies, and o
Hi all,
I have moved a lot of old records from one table say original_data_table to
another table say old_data_table which is newly created for the old records.
There were around 15 milliion old records to move. After this migration I have
done standard vacuum on new old_data_table as well as o
Read Manual First : http://www.postgresql.org/docs/9.2/static/index.html
However you should ask this in separate thread. This thread is related to :
LogStash For Analysing Postgres DB server Logs
Thanks
On Thu, Sep 5, 2013 at 10:40 AM, M Tarkeshwar Rao <
m.tarkeshwar@ericsson.com> wrote:
>
On 9/4/2013 10:13 PM, M Tarkeshwar Rao wrote:
Can you please suggest me some links where I can learn:
1.Transaction Isolation in Database
the documentation
2.Query procession and possible optimizations.
the source code. if there were any easy optimizations, I'm sure
they've already
David Johnston yahoo.com> writes:
>
> Trigve Siver wrote
> > I want to iterate all records with cursor from beginning to end. This
> > sample could be rewritten using FETCH FORWARD 1 ... without using MOVE but
> > I'm interested with solution which throws error.
>
> Is you interest purely acade
Hello Friends,
I want start contributing in Postgres in code level. I read some ppts and some
tutorials in postgres manual.
Can you please suggest me some links where I can learn:
1. Transaction Isolation in Database
2. Query procession and possible optimizations.
3. How to
Hello Friends,
I want start contributing in Postgres in code level. I read some ppts and some
tutorials in postgres manual.
Can you please suggest me some links where I can learn:
1. Transaction Isolation in Database
2. Query procession and possible optimizations.
3. How to
Hi,
Anyone has any experience of using LogStash for analysing DB server logs
real time. I used Pgbadger and find it very useful but need to test
Logstash as well.
Any link where I can find more details ?
Thanks
On 09/04/2013 02:04 PM, Richard Sickler wrote:
How about an elephant flying around Earth.
Caption: PostgreSQL - Used all around the World
I can hear the Disney lawyers cranking up the legal machinery as we speak:)
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing
On Wed, September 4, 2013 22:26, Andreas 'ads' Scherbaum wrote:
> Do you have a cool idea? Please let us know. Either reply here or send
http://imgur.com/eMyw6
Not really new (nor my own) but I think it could work well on a black mug.
Erik Rijkers
--
Sent via pgsql-general mailing li
How about an elephant flying around Earth.
Caption: PostgreSQL - Used all around the World
On Wed, Sep 4, 2013 at 1:58 PM, Gavin Flower
wrote:
> On 05/09/13 08:40, patrick keshishian wrote:
>
> On 9/4/13, Andreas 'ads' Scherbaum
> wrote:
>
> On 09/04/2013 10:17 PM, Stefan Kaltenbrunner wro
On 9/4/2013 2:59 PM, Andreas 'ads' Scherbaum wrote:
On 09/04/2013 10:55 PM, Erik Rijkers wrote:
On Wed, September 4, 2013 22:26, Andreas 'ads' Scherbaum wrote:
Do you have a cool idea? Please let us know. Either reply here or send
http://imgur.com/eMyw6
Not really new (nor my own) but I th
On 05/09/13 08:40, patrick keshishian wrote:
On 9/4/13, Andreas 'ads' Scherbaum wrote:
On 09/04/2013 10:17 PM, Stefan Kaltenbrunner wrote:
On 09/04/2013 10:13 PM, Marc Balmer wrote:
Am 04.09.13 22:02, schrieb Gavin Flower:
On 04/09/13 22:47, Eduardo Morras wrote:
On Wed, 04 Sep 2013 00:08:5
On 09/04/2013 10:55 PM, Erik Rijkers wrote:
On Wed, September 4, 2013 22:26, Andreas 'ads' Scherbaum wrote:
Do you have a cool idea? Please let us know. Either reply here or send
http://imgur.com/eMyw6
Not really new (nor my own) but I think it could work well on a black mug.
I think we a
On 04/09/13 22:47, Eduardo Morras wrote:
On Wed, 04 Sep 2013 00:08:52 +0200
Andreas 'ads' Scherbaum wrote:
PostgreSQL folks!
We are looking for the next big thing. Actually, it's a bit smaller: a
new design for mugs. So far we had big blue elephants, small blue
elephants, frosty elephants, wh
On 9/4/13, Andreas 'ads' Scherbaum wrote:
> On 09/04/2013 10:17 PM, Stefan Kaltenbrunner wrote:
>> On 09/04/2013 10:13 PM, Marc Balmer wrote:
>>> Am 04.09.13 22:02, schrieb Gavin Flower:
On 04/09/13 22:47, Eduardo Morras wrote:
> On Wed, 04 Sep 2013 00:08:52 +0200
> Andreas 'ads' Sche
Hello people.
I'm developing a reverse engineering feature for my project and I'm having
problems with sequences.
Basically, I'm trying to get sequence attributes by query
pg_catalog.pg_class as well information_schema.sequences. But in PostgreSQL
9.0 this latter table is not filled in all fields
On 9/3/2013 3:08 PM, Andreas 'ads' Scherbaum wrote:
We are looking for the next big thing. Actually, it's a bit smaller: a
new design for mugs. So far we had big blue elephants, small blue
elephants, frosty elephants, white SQL code on black mugs ... Now it's
time to design something new.
Wh
On 09/04/2013 10:17 PM, Stefan Kaltenbrunner wrote:
On 09/04/2013 10:13 PM, Marc Balmer wrote:
Am 04.09.13 22:02, schrieb Gavin Flower:
On 04/09/13 22:47, Eduardo Morras wrote:
On Wed, 04 Sep 2013 00:08:52 +0200
Andreas 'ads' Scherbaum wrote:
PostgreSQL folks!
We are looking for the next b
Trigve Siver wrote
> I want to iterate all records with cursor from beginning to end. This
> sample could be rewritten using FETCH FORWARD 1 ... without using MOVE but
> I'm interested with solution which throws error.
Is you interest purely academic or is there some reason you were evaluating
thi
>
> From: Giuseppe Broccolo
>To: pgsql-general@postgresql.org
>Sent: Wednesday, September 4, 2013 6:26 PM
>Subject: Re: [GENERAL] FETCH FORWARD 0 and "cursor can only scan forward"
>error
>
>
>
>Hi Trigve,
>
>Il 04/09/2013 15:06, Trigve Siver ha scritto:
>
>Hi,
Evan Martin wrote
> Also, even without --clean I get 3 errors:
>
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 6755; 2618 4417788 RULE
> geometry_columns_delete em
> pg_restore: [archiver (db)] could not execute query: ERROR: rule
>
Evan Martin wrote
> When I use pg_restore with --clean to restore a PostgreSQL 9.2.4database
> into a new, blank database it generates thousands of error messages like
> this:
>
> pg_restore: [archiver (db)] could not execute query: ERROR: schema
> "myschema" does not exist
> Command was:
Raphael Araújo e Silva escribió:
> My doubt: Is there some way to get all sequences attributes at once
> without execute repeatedly SELECT * FROM [sequence_name]?
I don't think there is, yet.
> Also, I'm wondering if there is some way to resolve a sequence OID into
> it's real representation. L
Trigve Siver writes:
> yes I know that when specifying "FORWARD 0" that no move is done and
> actual record is returned. But my question is why it is forbidden by "NO
> SCROLL"?
Because it's implemented as "back up 1 row and re-fetch".
regards, tom lane
--
Sent via pgs
> From: Tom Lane
> To: Trigve Siver
> Cc: "pgsql-general@postgresql.org"
> Sent: Wednesday, September 4, 2013 7:04 PM
> Subject: Re: [GENERAL] FETCH FORWARD 0 and "cursor can only scan forward"
> error
>
>T rigve Siver writes:
>> yes I know that when specifying "FORWARD 0" that no move is
I'm not sure I see the problem. The rule name is only unique within the
table, so it would not replace a rule on a different table (or view, as
is the case here) than the one being restored. Functions names should be
schema-qualified and if I'm restoring a function from a backup I would
want an
On 09/03/2013 04:38 PM, Gregory Haase wrote:
>
> So, my conclusion is that the generic function will work, and it will
> make administration (even automated administration) of partitioned
> tables much simpler.
>
> My question is... Is there a compelling reason why I should NOT do
> this. I must
Hi Trigve,
Il 04/09/2013 15:06, Trigve Siver ha scritto:
Hi,
I'm on PostgreSQL 9.2.2 and trying to use no scroll cursor for some data fetch. But when
moving cursor ahead one record and the fetching the actual record the error "cursor
can only scan forward" is returned. I don't know if I'm doin
Hello, everbody
I have the following problem: My vacuum is running since 2013-08-27
18:58:41.527238-03.
billing=# SELECT localtimestamp(0);
-[ RECORD 1 ]--
timestamp | 2013-09-04 11:23:06
billing=# SELECT
pg_stat_activity.procpid,pg_stat_activity.current_query,pg_stat_activity.qu
On 09/04/2013 07:02 AM, Evan Martin wrote:
Also, even without --clean I get 3 errors:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 6755; 2618 4417788 RULE
geometry_columns_delete em
pg_restore: [archiver (db)] could not execute query:
When I use pg_restore with --clean to restore a PostgreSQL 9.2.4database
into a new, blank database it generates thousands of error messages like
this:
pg_restore: [archiver (db)] could not execute query: ERROR: schema
"myschema" does not exist
Command was: DROP INDEX myschema.some_index
Hi,
I'm on PostgreSQL 9.2.2 and trying to use no scroll cursor for some data fetch.
But when moving cursor ahead one record and the fetching the actual record the
error "cursor can only scan forward" is returned. I don't know if I'm doing
something wrong but I don't think I'm going backward with
On Wed, 04 Sep 2013 00:08:52 +0200
Andreas 'ads' Scherbaum wrote:
>
> PostgreSQL folks!
>
> We are looking for the next big thing. Actually, it's a bit smaller: a
> new design for mugs. So far we had big blue elephants, small blue
> elephants, frosty elephants, white SQL code on black mugs ..
On Wed, Sep 4, 2013 at 2:10 AM, Jeff Janes wrote:
> On Tuesday, September 3, 2013, Gregory Haase wrote:
>
>> I am working on a date-based partitioning framework and I would really
>> like to have a single function that could be used as trigger for any table
>> that needs to be partitioned by day.
35 matches
Mail list logo
