sql-cluster.html)
that will physically rewrite the table.
However note it will require an Access Exclusive lock on the table
preventing any other activity on the table.
Chris Ellis
**
If you are not the intended recipient
Note that most data stored in the TOAST table is compressed.
IE a Text type with length greater than around 2K will be stored in the
TOAST table. By default data in the TOAST table is compressed, this can
be overriden.
However I expect that compression will reduce the performance of certain
ntory WHERE modified >=
'2010-01-20') AS "COUNT_2",
(SELECT COUNT(distinct model) FROM inventory WHERE modified >=
'2010-01-01') AS "COUNT_3"
;
PostgreSQL allows sub-queries in the select list as long as the sub-qu
odified >= '2010-01-20') AS "COUNT_2",
> >(SELECT COUNT(distinct model) FROM inventory WHERE
> > modified >= '2010-01-01') AS "COUNT_3"
> > ;
> >
> > PostgreSQL allows sub-queries in the select list as long as
efore can only tell you how I approached a similar problem.
I hope that is of some use.
Chris Ellis
pgsql-general-ow...@postgresql.org wrote on 04/09/2010 02:53:19 PM:
> Hi,
>
> nobody here who knows how to get the postgre fulltext working with
> ispell and stemming? :-(
>
> So th
insert into auth (user_id, salt, password) values
(1,'blah',md5('blah' || 'test') || sha1('blah' || 'test')) ;
then to check the password
select true from auth where user_id = 1 and password = md5( salt
|| 'test&#
controllers would anyone recommend purchasing?
Any information is gratefully received
Chris Ellis
Shropshire Council
chris.el...@shropshire.gov.uk
**
If you are not the intended recipient of this email please do not send it
sing?
>
> I am using an Areca 1680 series controller. 16 SAS 15k5 disks. 2
> RAID-1, 12 RAID-10, 2 hot spares. 512Meg bbu. RHEL 5.2 I can sustain
> around 3000 tps with pgbench and 30 minute runs.
Thanks for the Info.
>
> I'd call IBM and ask them to come pick up their
unately, I seem stuck with them :(
>
> Can you at least source your own RAID controllers?
Yes I will be, I never really did trust IBM and I certainly don't now!
I just need to choose the correct RAID card now, good performance at the
right price.
Chris Ellis
***
Stefan Kaltenbrunner wrote on 01/04/2009
06:53:07:
> chris.el...@shropshire.gov.uk wrote:
> >
> > Scott Marlowe wrote on 31/03/2009 15:53:34:
> >
> > > On Tue, Mar 31, 2009 at 8:21 AM,
wrote:
> > > >
> > > > Scott Marlowe wrote on 31/03/2009
15:16:01:
> > > >
> > > >> I'd call IBM a
atabase the correct tool for the job if you want this level of
encryption and granularity?
Also, how secure are you communication channels, what stops me snooping
the data in transit, ARP posioning and other techniques etc.
Chris Ellis
***
> > Take the performance hit, If people on high want the data encrypted,
then
> > they have to suffer the performance penalty, however bad.
>
> As reasonable as that sounds, I don't think it's true. We've already
> brainstormed a dozen ways to work around the performance issue (creative
> hash
12 matches
Mail list logo
