On 08/21/2012 09:40 PM, David Boreham wrote:
On 8/21/2012 2:18 AM, Vincent Veyron wrote:
I wonder : is there a reason why you have to go through the complexity
of such a setup, rather than simply use bare metal and get good
performance with simplicity?
In general I agree -- it is much (much!) c
On 08/22/2012 12:27 PM, Wells Oliver wrote:
We have a lot of tables which store numeric data. These tables all use
the numeric type, where the values are 95% integer values. We used
numeric because it eliminated the need for casting during division to
yield a floating point value.
I'm curious as
We have a lot of tables which store numeric data. These tables all use the
numeric type, where the values are 95% integer values. We used numeric
because it eliminated the need for casting during division to yield a
floating point value.
I'm curious as to whether this would have performance and/or
You appear to have replied directly to me rather than the list, so I've
cc'd the list.
On 08/21/2012 10:11 PM, Evil wrote:
Dear Craig Ringer And Dear Thom!
THANK YOU VERY MUCH for such Great and easy explanation!
Now everything seems is kk with grants.From now i think i understand
how to sep
On Tue, Aug 21, 2012 at 10:12 PM, Scott Marlowe wrote:
> On Tue, Aug 21, 2012 at 10:08 PM, Scott Marlowe
> wrote:
>> On Tue, Aug 21, 2012 at 3:29 PM, Michael Clark wrote:
>>> For example, if I insert like so:
>>> INSERT INTO sometable (startdate) values ('1750-08-21 21:17:00+00:00');
>>
>> What
--
Wells Oliver
wellsoli...@gmail.com
On Tue, Aug 21, 2012 at 10:08 PM, Scott Marlowe wrote:
> On Tue, Aug 21, 2012 at 3:29 PM, Michael Clark wrote:
>> For example, if I insert like so:
>> INSERT INTO sometable (startdate) values ('1750-08-21 21:17:00+00:00');
>
> What's the reason for you inserting with an offest instead of letting
On Tue, Aug 21, 2012 at 3:29 PM, Michael Clark wrote:
> For example, if I insert like so:
> INSERT INTO sometable (startdate) values ('1750-08-21 21:17:00+00:00');
What's the reason for you inserting with an offest instead of letting
the client timezone set it for you? Just wondering.
--
Sent
On 08/21/2012 04:45 PM, Seref Arikan wrote:
Parallel software frameworks such as Erlang's OTP or Scala's Akka do
help a lot, but it would be a lot better if I could feed those
frameworks with data faster. So, what options do I have to execute
queries in parallel, assuming a transactional system
Hello.
Thanks for the response.
The value being returned from PG, with the odd offset is expected?
Thanks again,
Michael.
On Tue, Aug 21, 2012 at 5:50 PM, Steve Crawford <
scrawf...@pinpointresearch.com> wrote:
> On 08/21/2012 02:29 PM, Michael Clark wrote:
>
>> Hello all,
>>
>> I have a weir
Hi,
On 22 August 2012 07:07, Menelaos PerdikeasSemantix
wrote:
> Let's say you have a father-child (or master-detail if you wish) hierarchy
> of tables of not just 2 levels, but, say, 5 levels.
> E.g. tables A, B, C, D and E organized in successive 1-to-N relationships:
>
> A 1-to-N-> B
On 08/21/2012 02:29 PM, Michael Clark wrote:
Hello all,
I have a weird situation I am trying to work through, and could use
some help if anyone can provide some.
I have a table with a column to store timestamp with time zone, and
when I store an older take (before 1895 or so), the value I ge
Hello all,
I have a weird situation I am trying to work through, and could use some
help if anyone can provide some.
I have a table with a column to store timestamp with time zone, and when I
store an older take (before 1895 or so), the value I get back from PG when
doing a select seems odd and i
Depending on your problem domain, it might make sense to have multi-column
primary keys in some non-A tables, where a subset of their columns are the
foreign keys to the parents. In that case, you can skip some intermediary
tables in the joins. However, this would increase the size of your ind
Oops sorry, I thought I did hit reply all.
I am not sure this mailing list is the right place to have this debate
(assuming it is needed, there are plenty of articles stating the benefits
of using the cloud), so I will simply answer that you pay the cost of the
added layer up front (mostly scripti
Le mardi 21 août 2012 à 09:36 -0500, Merlin Moncure a écrit :
> here's a datapoint, stock config:
> pgbench -i -s 500
> pgbench -c 16 -T 60
> number of transactions actually processed: 418012
> tps = 6962.607292 (including connections establishing)
> tps = 6973.154593 (excluding connections establ
On Tue, Aug 21, 2012 at 12:33 AM, Sébastien Lorion
wrote:
> Hello,
>
> Since Amazon has added new high I/O instance types and EBS volumes, anyone
> has done some benchmark of PostgreSQL on them ?
>
> http://perspectives.mvdirona.com/2012/07/20/IOPerformanceNoLongerSucksInTheCloud.aspx
> http://per
On 8/21/2012 2:18 AM, Vincent Veyron wrote:
I wonder : is there a reason why you have to go through the complexity
of such a setup, rather than simply use bare metal and get good
performance with simplicity?
In general I agree -- it is much (much!) cheaper to buy tin and deploy
yourself vs any o
On 8/21/2012 7:10 AM, Oliver Kohll - Mailing Lists wrote:
This is a general 'cloud or dedicated' question, I won't go into it
but I believe cloud proponents cite management ease, scalability etc.
I'm sure there's a place for every type of hosting. However I would be
interested in hearing some
On 21 Aug 2012, at 13:32, Vincent Veyron wrote:
>>
>> Since Amazon has added new high I/O instance types and EBS volumes,
>> anyone has done some benchmark of PostgreSQL on them ?
>>
>
> I wonder : is there a reason why you have to go through the complexity
> of such a setup, rather than simpl
Hermano Cabral wrote:
> Does anyone know if its possible to use entity framework code first with the
> npgsql connector? I know
> devart's connector does the job, but I'm low on funds for this project and
> their stuff is not cheap.
Yes, Npgsql supports Entity Framework.
For questions concernin
I was wondering why it seems that the query planner can't "see", based
on the histograms, that two join-columns have a very small
intersection, and adjust its row estimation accordingly. Clearly the
below query returns 1001 rows. It appears as if much or all of the
necessary machinery exists in m
Hi,
I'm trying to reduce the re-computing of window aggregation. Here the
AVG function for example.
The original window aggregation's transition value(transValue) of AVG is
an ArrayType, that contains two main values(sum, count).
Now, I'm using a temporary transition value (tempTransVa
Hello
2012/8/21 Seref Arikan :
> Dear all,
> I am designing an electronic health record repository which uses postgresql
> as its RDMS technology. For those who may find the topic interesting, the
> EHR standard I specialize in is openEHR: http://www.openehr.org/
>
http://stormdb.com/community/st
Dear all,
I am designing an electronic health record repository which uses postgresql
as its RDMS technology. For those who may find the topic interesting, the
EHR standard I specialize in is openEHR: http://www.openehr.org/
My design makes use of parallel execution in the layers above DB, and it
Le mardi 21 août 2012 à 01:33 -0400, Sébastien Lorion a écrit :
>
>
> Since Amazon has added new high I/O instance types and EBS volumes,
> anyone has done some benchmark of PostgreSQL on them ?
>
I wonder : is there a reason why you have to go through the complexity
of such a setup, rather th
Le mardi 21 août 2012 à 01:33 -0400, Sébastien Lorion a écrit :
>
>
> Since Amazon has added new high I/O instance types and EBS volumes,
> anyone has done some benchmark of PostgreSQL on them ?
>
I wonder : is there a reason why you have to go through the complexity
of such a setup, rather th
On 08/21/2012 03:01 PM, Martijn van Oosterhout wrote:
Well, Postgres in principle supports arrays of records, so I've
wondered if a relationship join could stuff all the objects in a single
field of the response using an aggregate. I think what's always
prevented this from working is that client
Hello List,
First time here also beginner to Postgres.So please forgive me for any mistakes.
I'm pretty sure i have same problem.=>
http://archives.postgresql.org/pgsql-admin/2012-03/msg00105.php
(After searching it i found it)
However it is not solution for me.:( *I'm pretty sure i'm doing somet
On Tue, Aug 21, 2012 at 09:39:20AM +0800, Craig Ringer wrote:
> On 08/21/2012 03:06 AM, Martijn van Oosterhout wrote:
> >I'm not sure I have an opinion on pushing ORM features to the database
> >layer, SQLAlchemy is doing a pretty good job for me already.
>
> There are some things ORMs could reall
30 matches
Mail list logo
