Hi all,
Today after upgrading to 9.2 from 9.0 I faced a very odd
incompatibility that seems to me as a bug:
smoking_test=# select timeofday(), clock_timestamp();
timeofday |clock_timestamp
-+---
Sa
On 03/23/2013 12:37 AM, Sergey Konoplev wrote:
Hi all,
Today after upgrading to 9.2 from 9.0 I faced a very odd
incompatibility that seems to me as a bug:
smoking_test=# select timeofday(), clock_timestamp();
timeofday |clock_timestamp
---
On 03/23/2013 12:37 AM, Sergey Konoplev wrote:
Hi all,
Today after upgrading to 9.2 from 9.0 I faced a very odd
incompatibility that seems to me as a bug:
smoking_test=# select timeofday(), clock_timestamp();
timeofday |clock_timestamp
---
Adrian Klaver writes:
> Seems the time zone info still thinks Moscow time is being setting
> forward an hour for DST when in fact the time remains constant through
> the year.
I think the discrepancy is between this in timezone/data/europe:
Zone Europe/Moscow 2:30:20 - LMT 1880
On 2013-03-20, David Rees wrote:
> On Wed, Mar 20, 2013 at 12:37 PM, David Rees wrote:
>> PostgreSQL 8.4.16 on CentOS 5.9.
>>
>> I've run into a situation where executing a \COPY from psql will hang
>> and at that point it's impossible to terminate the COPY command.
>
> Some additional notes:
>
>
Hi,
I am trying to make a decision in choose between these following servers:
1) HP DL 380 G4
Intel Xeon 3.2GHZ 2MB cache
8 GB Ram
RAID -1 73GB SCSI 10K RPM (for OS)
Raid -1 300GB SCSI 10K RPM (data)
2) Sunfire X4150
Intel Xeon E5450 @ 3.0 GHZ 6MB cache
4GB RAM
RAID
On 2013-03-20, jg wrote:
> Hi,
>
> I have a PostgreSQL database with 50 tables.
> Every minute, sequentially, a batch load 10.000 rows of 250 bytes with a COPY.
>
> After a day, i got a database with 50 tables with 1.440 set of 10.000 rows.
> The tables are cleany and naturally clustered by the in
On 03/23/2013 08:16 AM, Tom Lane wrote:
Adrian Klaver writes:
Seems the time zone info still thinks Moscow time is being setting
forward an hour for DST when in fact the time remains constant through
the year.
I think the discrepancy is between this in timezone/data/europe:
Zone Europe/Mosco
On 2013-03-22, Ryan Kelly wrote:
> On Fri, Mar 03/22/13, 2013 at 06:16:11AM -0700, Adrian Klaver wrote:
>> On 03/22/2013 05:32 AM, Bertrand Janin wrote:
>> >I noticed how rows were re-written to a different location (new ctid) even
>> >without changes to the values. This illustrate what I mean:
>>
On 3/23/2013 4:03 PM, Kenroy Bennett wrote:
I welcome your advice on choosing between these systems
those are both obsolete systems several generations old. The HP DL
stuff is g7 or g8 now, not g4. that sunfire is newer, but doesn't have
much ram, at least by modern database server stand
On Sat, Mar 23, 2013 at 1:50 AM, Bertrand Janin wrote:
> Tom is right, this would be an optimization for a corner case, I noticed this
> when running a generated script for a batch update that wasn't given a ton of
> attention. The BEFORE UPDATE trigger will work great.
If you know the app, just
HI,
When I have met PostgreSQL for a first time - I have been really amazed -
with many things...
But how we started to use it - and data jumps in - we meet performance
problems...
Now, it is a bit tricky... any concrete performance problem - can be solved
on some way...
However, I am more conc
Hi a couple of things:
from some unknown reason - gives bad plan - then if we "refactor" query and
> send different question - we get good result... I am pretty sure planner
> should be capable to "rephrase" my question instead of me...
You seem to be comparing PostgreSQL performance to some oth
Não consigo fazer a conexão no windows 7 só no XP, porque?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
14 matches
Mail list logo
