On Sat, Aug 29, 2009 at 6:26 AM, Merlin Moncure wrote:
> On Fri, Aug 28, 2009 at 8:19 PM, Jeff Janes wrote:
> >> -- Forwarded message --
> >> From: Joseph S
> >> To: Greg Smith , pgsql-performance@postgresql.org
> >> Date: Fri, 28 Aug 2009 10:25:10 -0400
> >> Subject: Re: What ex
On Sat, Aug 29, 2009 at 10:45 PM, Tom Lane wrote:
> Jean-Michel =?ISO-8859-1?Q?Pour=E9?= writes:
>> What do you recommend: using normal types and moving constraints in the
>> Drupal database? Is PostgreSQL domain broken as it forces casting or is
>> this a no-op for performance?
>
> In principle i
Jean-Michel =?ISO-8859-1?Q?Pour=E9?= writes:
> What do you recommend: using normal types and moving constraints in the
> Drupal database? Is PostgreSQL domain broken as it forces casting or is
> this a no-op for performance?
In principle it should be an unnoticeable slowdown. In the past we've
h
Le samedi 29 août 2009 à 13:44 -0400, Tom Lane a écrit :
> That domain doesn't have any operators of its own. To compare to
> another value, or use an index, you have to cast it to integer which
> does have operators. It's a no-op cast, but logically necessary.
Dear Tom,
Thanks for answering. O
On Sat, Aug 29, 2009 at 1:46 AM, Greg Stark wrote:
> On Sat, Aug 29, 2009 at 5:20 AM, Luke Koops wrote:
>> RAID-5 can be much faster than RAID-10 for random reads and writes. It is
>> much slower than
>> RAID-10 for sequential writes, but about the same for sequential reads. For
>> typical acce
Jean-Michel =?ISO-8859-1?Q?Pour=E9?= writes:
> In Drupal database, we have two types:
> CREATE DOMAIN int_unsigned
> AS integer
> CONSTRAINT int_unsigned_check CHECK ((VALUE >= 0));
> Why do queries cast between integer and int_unsigned?
That domain doesn't have any operators of its own. To c
Le samedi 29 août 2009 à 11:16 -0400, Bruce Momjian a écrit :
> > Why is the query planner displaying ::integer
> > What does it mean?
>
> ::integer casts a data type to INTEGER. It is the same as CAST().
In Drupal database, we have two types:
integer
int_unsigned
CREATE DOMAIN int_unsigned
Jean-Michel Pour? wrote:
-- Start of PGP signed section.
> Le jeudi 27 ao?t 2009 ? 14:05 -0400, Tom Lane a ?crit :
> > tom lane
>
> Dear Tom,
>
> Why is the query planner displaying ::integer
> What does it mean?
::integer casts a data type to INTEGER. It is the same as CAST().
--
Bruce Mo
On Sat, Aug 29, 2009 at 2:46 AM, Greg Stark wrote:
> On Sat, Aug 29, 2009 at 5:20 AM, Luke Koops wrote:
>> Joseph S Wrote
>>> If I have 14 drives in a RAID 10 to split between data tables
>>> and indexes what would be the best way to allocate the drives
>>> for performance?
>>
>> RAID-5 can be much
On Fri, Aug 28, 2009 at 8:19 PM, Jeff Janes wrote:
>> -- Forwarded message --
>> From: Joseph S
>> To: Greg Smith , pgsql-performance@postgresql.org
>> Date: Fri, 28 Aug 2009 10:25:10 -0400
>> Subject: Re: What exactly is postgres doing during INSERT/UPDATE ?
>> Greg Smith wrote:
>
On Sat, Aug 29, 2009 at 5:20 AM, Luke Koops wrote:
> Joseph S Wrote
>> If I have 14 drives in a RAID 10 to split between data tables
>> and indexes what would be the best way to allocate the drives
>> for performance?
>
> RAID-5 can be much faster than RAID-10 for random reads and writes. It is
>
11 matches
Mail list logo