We're looking to deploy a bunch of new machines.
Our DB is fairly small and write-intensive. Most of the disk
traffic is PG WAL. Historically we've avoided
RAID controllers for various reasons, but this new deployment will be
done with them (also for various reasons ;)
We like to use white-boxis
On 06/17/2011 01:02 PM, Scott Ribe wrote:
1) Is my impression correct that given a choice between Areca& Highpoint, it's
a no-brainer to go with Areca?
I guess you could call Highpoint a RAID manufacturer, but I wouldn't do
so. They've released so many terrible problems over the years t
On 06/17/2011 06:50 PM, hyelluas wrote:
I'm looking into pg_tables view and only one tablespace is displayed is
pg_global.
All my tables are created in my custom tablespace and that column is empty
for them.
I'm not sure what's wrong here, but the query you are trying to use to
decode this
Iain Barnett wrote:
> Hi,
>
> I'm currently running 8.4.4. I downloaded the source for 9.0.4 and
> installed it, and then installed pg_upgrade and ran it, and got the
> following message:
>
> > This utility can only upgrade to PostgreSQL version 9.0.
>
> It seems strange to me that it can only u
Hello
PostgreSQL doesn't support MERGE statement yet
Regards
Pavel Stehule
2011/6/17 Leon Match :
> Hello,
>
>
>
> I am trying to move few objects to postgres from oracle.
>
>
>
> I have an issue with a trigger, which has a merge inside?
>
>
>
> Here is my code:
>
> BEGIN
>
> MERGE INTO Req
bubba postgres writes:
> This is the reverse of what I thought I would find.
> In short my check constraint is extracting the epoch from a start timestamp,
> and an end timestamp to get the number of seconds difference.
> It then uses this number to check the array_upper() of an array to make sure
I know I can setup a FK constraint to make sure Table1.ColA exists in
Table2.Key, however what if I want to do the reverse?
I want to ensure Table1.ColA does NOT exist in Table2.Key.. Can I do
this with any sort of CHECK constraint, trigger, custom function, etc?
Than
hello,
I'm looking into pg_tables view and only one tablespace is displayed is
pg_global.
All my tables are created in my custom tablespace and that column is empty
for them.
select * from pg_tablespace show my tablespace, pgAdmin shows that
tablespace for each table. I need to query the data di
This is the reverse of what I thought I would find.
In short my check constraint is extracting the epoch from a start timestamp,
and an end timestamp to get the number of seconds difference.
It then uses this number to check the array_upper() of an array to make sure
it's the proper size
The SQL
Hello,
I am trying to move few objects to postgres from oracle.
I have an issue with a trigger, which has a merge inside?
Here is my code:
BEGIN
MERGE INTO Requests r
using (select
new.web_form_id web_form_id,
new.form_type form
bubba postgres writes:
> Are there any optimizations around check constraints such that they will not
> be evaluated if constituent columns are not updated?
Nope.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
Are there any optimizations around check constraints such that they will not
be evaluated if constituent columns are not updated?
Regards,
-JD
On Fri, Jun 17, 2011 at 11:35 AM, Scott Ribe
wrote:
> It's small enough that there's some other things going on at the same small
> server with 4 disk bays ;-) My thinking was that write-back cache might
> mitigate the poor write performance enough to not be noticed. This db doesn't
> generally
On Jun 17, 2011, at 11:20 AM, Scott Marlowe wrote:
> Generally, yes, but the model of the card is more important than the
> maker. I.e. an Areca 1880 or 1680 is a fantastic performer. But the
> older 1120 series aren't gonna set the world on fire or anything.
And, in further digging, I discover
On 17 June 2011 04:44, Robert Haas wrote:
> On Wed, Feb 9, 2011 at 4:50 AM, Thom Brown wrote:
>> On 9 February 2011 02:11, Robert Haas wrote:
>>> On Tue, Feb 8, 2011 at 8:30 PM, Andrew Dunstan wrote:
Quite right, but the commitfest manager isn't meant to be a substitute for
one. Bug f
Robert Haas writes:
> So, I finally got around to look at this, and I think there is a
> simpler solution. When an overflow occurs while calculating the next
> value, that just means that the value we're about to return is the
> last one that should be generated. So we just need to frob the
> co
>
> On Wed, Feb 9, 2011 at 4:50 AM, Thom Brown wrote:
> > On 9 February 2011 02:11, Robert Haas wrote:
> >> On Tue, Feb 8, 2011 at 8:30 PM, Andrew Dunstan
> wrote:
> >>> Quite right, but the commitfest manager isn't meant to be a
> >>> substitute for one. Bug fixes aren't subject to the same re
On Fri, Jun 17, 2011 at 10:39 AM, David Johnston wrote:
> Tangential comment but have you considered emitting a warning (and/or log
> entry) when you are 10,000-50,000 away from issuing the last available
> number in the sequence so that some recognition exists that any code
> depending on the seq
Robert Haas writes:
> On Fri, Jun 17, 2011 at 2:15 PM, Tom Lane wrote:
>> BTW, there was some mention of changing the timestamp versions of
>> generate_series as well, but right offhand I'm not convinced that
>> those need any change. I think you'll get overflow detection there
>> automatically
On Fri, Jun 17, 2011 at 2:15 PM, Tom Lane wrote:
> Robert Haas writes:
>> So, I finally got around to look at this, and I think there is a
>> simpler solution. When an overflow occurs while calculating the next
>> value, that just means that the value we're about to return is the
>> last one tha
I'm working with a product that uses effective date based data structures. We
then create views using analytic functions that have begin and end dates for
when that record was valid. This works fine when there is just one record per
item that is valid at any given time (for instance job assignme
Thanks much for the specific info on Areca RAID cards. Very helpful.
On Jun 17, 2011, at 11:20 AM, Scott Marlowe wrote:
> The problem with RAID-5 is crappy write performance. Being big or
> small won't change that. Plus if the db is small why use RAID-5?
It's small enough that there's some oth
On Fri, Jun 17, 2011 at 11:02 AM, Scott Ribe
wrote:
> No responses to my earlier post, I'm assuming because OS X experience is
> rather thin in this group ;-) So a couple of more specific questions:
>
> 1) Is my impression correct that given a choice between Areca & Highpoint,
> it's a no-braine
No responses to my earlier post, I'm assuming because OS X experience is rather
thin in this group ;-) So a couple of more specific questions:
1) Is my impression correct that given a choice between Areca & Highpoint, it's
a no-brainer to go with Areca?
2) I understand why RAID 5 is not general
On 6/14/2011 8:08 PM, David Johnston wrote:
alter table tblissue add constraint
"tblissue_parentissueid_fkey_casc_del" FOREIGN KEY (parentissueid)
REFERENCES tblissue(issueid) ON DELETE CASCADE;
=
Then:
delete from tblissue where issueid=1;
DELETE 1
P
[please don't send a post to multiple lists]
Pratheeban Jebasingh Tharmaraj wrote:
> I am trying to add column to the table that's hanging.
>
> alter table hr_firms add column_name biginit;
>
> This is the lock I see in the db
>
> relation | 564709 | 586888 | | |
On Wed, Feb 9, 2011 at 4:50 AM, Thom Brown wrote:
> On 9 February 2011 02:11, Robert Haas wrote:
>> On Tue, Feb 8, 2011 at 8:30 PM, Andrew Dunstan wrote:
>>> Quite right, but the commitfest manager isn't meant to be a substitute for
>>> one. Bug fixes aren't subject to the same restrictions of f
Hi, I'm used to work with PostgreSQL on Windows but now I've moved to OS X
and I'm having problems to create a service to auto start a new server
(instance) of PostgreSQL.
Firstly I used the PostgreSQL installer to create the first server and the
postgres user, then I used initdb to create another
We are expecting following advantages through this,
Unauthorized use either by the
1. DB administrator
2. ex-developer Or
3. Any body
This why PostgreSQL has the concept of "ROLE"s.
The data, not the schema, is what needs to be secured.you are not preventing
unauthorized use only
Simon Windsor wrote:
> Can the performance of Postgres be boosted, especially on busy
systems, using the none default
> DEADLINE Scheduler?
I think that mostly depends on your storage.
I personally have made one experience where (after weeks of trying
everything
else) I changed the scheduler fro
BRUSSER Michael wrote:
>>> Is there a way to find the records with the text field containing
Unicode bytes "0xedbebf"?
>>> Unfortunately this is a very old version 7.3.10
>>
>> This should work on 7.3 (according to the documentation):
>> SELECT id FROM nlsdata WHERE position('\360\235\204\236'::byt
31 matches
Mail list logo