Hi!
I would also expect you to be able to make a Stored Procedure executing the
same command, although I never tried it myself.
Bèrto
On 8 September 2010 03:17, Fabrízio de Royes Mello
wrote:
>
> 2010/9/7 Isabella Ghiurea
>
> Hi List,
>> I would like to know if there is an option to run full v
On 2010-09-07 22:47, Scott Marlowe wrote:
Ok, recently I have compared prices a NexSan SASBeast with 42 15K SAS
drives
with a HP MDS600 with 15K SAS drives.
The first is 8gbit Fibre Channel, the last is 3Gbit DAS SAS. The
fibre channel version is about 20% more expensive pr TB.
So of course it
2010/9/7 Isabella Ghiurea
> Hi List,
> I would like to know if there is an option to run full vacuumdb for a
> specific schema only, I see there is option for tables or whole db .
>
>
No, but you can do like this using "psql" :
psql -U postgres -t -A -c "select 'VACUUM
'||table_schema||'.'||ta
Hi List,
I would like to know if there is an option to run full vacuumdb for a
specific schema only, I see there is option for tables or whole db .
Thank you
Isabella
--
---
Isabella A. Ghiurea
isabella.ghiu...@nrc-cnrc.gc.ca
Canadia
Hi everybody,
I have been reading this thread and I got the idea that
SANs to avoid, but would somebody please give a bit of
Comparison/perspective on NAS?
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
On 9/7/10 12:36 PM, "Craig James" wrote:
> On 9/7/10 12:06 PM, Jesper Krogh wrote:
>> On 2010-
On Tue, Sep 7, 2010 at 1:36 PM, Craig James wrote:
> On 9/7/10 12:06 PM, Jesper Krogh wrote:
>>
>> On 2010-09-07 20:42, Scott Marlowe wrote:
>>>
>>> With the right supplier, you can plug in literally 100 hard drives to
>>> a regular server with DAS and for a fraction of the cost of a SAN.
>>
>> Ok
On 9/7/10 12:06 PM, Jesper Krogh wrote:
On 2010-09-07 20:42, Scott Marlowe wrote:
With the right supplier, you can plug in literally 100 hard drives to
a regular server with DAS and for a fraction of the cost of a SAN.
Ok, recently I have compared prices a NexSan SASBeast with 42 15K SAS drives
On 2010-09-07 20:42, Scott Marlowe wrote:
With the right supplier, you can plug in literally 100 hard drives to
a regular server with DAS and for a fraction of the cost of a SAN.
Ok, recently I have compared prices a NexSan SASBeast with 42 15K SAS drives
with a HP MDS600 with 15K SAS drives
On Tue, Sep 7, 2010 at 9:42 AM, Joshua D. Drake wrote:
> On Tue, 7 Sep 2010 15:03:44 +0200, fel wrote:
>> Hi all,
>>
>> I am working on upgrading my hardware and wondering how Postgres could
>> work with SAN, NAS and DAS .
>> Can someone advise me or share experiences ?
>
> Unless you want to spe
While I agree with JD, we ended up using a fiber solution through a fiber
switch with multi-path drivers (IBM DS4300). It did end up costing a few
thousand dollars with all of the drives, but the performance made it worth it.
The big thing you want to remember to consider with any storage optio
fel wrote:
> I am working on upgrading my hardware and wondering how Postgres
> could work with SAN, NAS and DAS .
> Can someone advise me or share experiences ?
My experiences with SAN have been all bad. If you do consider SAN,
here's my checklist:
(1) Assume that every statement made by a
On Tue, 7 Sep 2010 15:03:44 +0200, fel wrote:
> Hi all,
>
> I am working on upgrading my hardware and wondering how Postgres could
> work with SAN, NAS and DAS .
> Can someone advise me or share experiences ?
Unless you want to spend *A LOT* of money, DAS is the way to go. You can
get quite a b
Hi all,
I am working on upgrading my hardware and wondering how Postgres could
work with SAN, NAS and DAS .
Can someone advise me or share experiences ?
Regards,
Fel
Hello,
(Postgres 8.3, Linux)
while trying to drop a tablespace, I get an error tablespace "xxx" is
not empty.
There are effectively a few files within the corresponding folder,
but all of them are empty and a few months old.
moreover, pg_class does not contain any references to
Hi all,
I am working on upgrading my hardware and wondering how Postgres could
work with SAN, NAS and DAS .
Can someone advise me or share experiences ?
Regards,
Fel
> -Original Message-
> From: Michael Monnerie [mailto:michael.monne...@is.it-management.at]
> Sent: Friday, September 03, 2010 9:03 AM
> To: pgsql-admin@postgresql.org
> Subject: fail-safe sql update triggers
>
> I want to log all activity from a table to a old_table.
> Creating an ON IN
16 matches
Mail list logo
