Thanks a lot for the advice Richard. I will try those things out and
report back to the list.
Carl
On 8/10/06, Richard Huxton wrote:
From your figures, you're allocating about 64MB to work_mem, which is
per sort. So, a complex query could use several times that amount. If
you don't have many
Merlin Moncure wrote:
On 8/10/06, Chris <[EMAIL PROTECTED]> wrote:
Sue Fitt wrote:
> Thanks Chris and Chris, you've solved it.
>
> I had a gui open that connects to the database. It was doing nothing
> (and not preventing me adding to or altering headwords_core via psql),
> but having closed it
On 8/10/06, Phil Cairns <[EMAIL PROTECTED]> wrote:
Hi all,
I have an application that uses PostgreSQL to store its data. The
application and an instance of the database have been installed in three
different locations, and none of these three locations have anything to
do with any of the others.
On 8/3/06, hansell baran <[EMAIL PROTECTED]> wrote:
Hi. I'm new at using PostgreSQL.
Where I work, all databases were built with MS Access. The Access files are
hosted by computers with Windows 2000 and Windows
XP. A new server is on its way and only Open Source Software is going to be
installed
On Aug 3, 2006, at 19:39 , hansell baran wrote:When we run the following query "SELECT * FROM big_table", we get the following resutls: Very different results are obtained if a the query "SELECT * from big_table ORDER BY "some_column"". In this scenario You should perform your test with queries wh
Hi all,
I have an application that uses PostgreSQL to store its data. The
application and an instance of the database have been installed in three
different locations, and none of these three locations have anything to
do with any of the others. I'm observing a problem in that large
transfers
contact1981 wrote:
Hello,
I am trying to migrate data from a DB2 database to SQL Server 2005
database. Does anyone know about any migration tool that does that? I
have heard about DB2 Migration Tool kit, but I think you can only
migrate data to a DB2 database with that. Thank you.
Sincerel
Hi. I'm new at using PostgreSQL.Where I work, all databases were built with MS Access. The Access files are hosted by computers with Windows 2000 and Windows XP. A new server is on its way and only Open Source Software is going to be installed. The OS is going to be SUSE Linux 10.1 and we are makin
Hello,
I am trying to migrate data from a DB2 database to SQL Server 2005
database. Does anyone know about any migration tool that does that? I
have heard about DB2 Migration Tool kit, but I think you can only
migrate data to a DB2 database with that. Thank you.
Sincerely,
Eldhose Cyriac
On Thu, 10 Aug 2006, Sue Fitt wrote:
> Hi all,
>
> This is my first post to the performance list, I hope someone can help me.
>
> I'm setting up a table with 2 columns, both of which reference a column
> in another table:
>
> CREATE TABLE headwords_core_lexemes (
> core_id int REFERENCES headwords
Please cc the list so others can help.
How large is the database? What indexes are on the tables you're inserting
into? What speed is the drive?
Since it's a single SCSI drive I'm assuming it's only 10k RPM, which means the
theoretical maximum you can hit is 160 transfers per second. At 40 inse
Michal Taborsky - Internet Mall wrote:
> Tom Lane napsal(a):
> >Michal Taborsky - Internet Mall <[EMAIL PROTECTED]> writes:
> >>SELECT product.product_id
> >> FROM action
> >> JOIN product ON (product.product_id=action.product_id)
> >> WHERE action.shop_group_id=1
> >>AND EXISTS (SELECT 1
Scott,I *could* rip out the LSI MegaRAID 2X from my Sun box. This belongs to me for testing. but I don't know if it will fit in the DL385. Do they have full-heigth/length slots? I've not worked on this type of box before. I was thinking this is the next step. In the meantime, I've discovered their
On Thu, 2006-08-10 at 10:15, Luke Lonergan wrote:
> Mike,
>
> On 8/10/06 4:09 AM, "Michael Stone" <[EMAIL PROTECTED]> wrote:
>
> > On Wed, Aug 09, 2006 at 08:29:13PM -0700, Steve Poe wrote:
> >> I tried as you suggested and my performance dropped by 50%. I went from
> >> a 32 TPS to 16. Oh well.
Mike,
On 8/10/06 4:09 AM, "Michael Stone" <[EMAIL PROTECTED]> wrote:
> On Wed, Aug 09, 2006 at 08:29:13PM -0700, Steve Poe wrote:
>> I tried as you suggested and my performance dropped by 50%. I went from
>> a 32 TPS to 16. Oh well.
>
> If you put data & xlog on the same array, put them on seper
On 8/10/06, Chris <[EMAIL PROTECTED]> wrote:
Sue Fitt wrote:
> Thanks Chris and Chris, you've solved it.
>
> I had a gui open that connects to the database. It was doing nothing
> (and not preventing me adding to or altering headwords_core via psql),
> but having closed it the table is instantly
On Aug 9, 2006, at 5:35 PM, Jim C. Nasby wrote:
Note that some controllers (such as 3ware) need to periodically
test the
life of the BBU, and they disable write caching when they do so, which
would tank performance.
Yep. I did the battery capacity test before I went live with our
9550sx c
On Wed, Aug 09, 2006 at 08:29:13PM -0700, Steve Poe wrote:
I tried as you suggested and my performance dropped by 50%. I went from
a 32 TPS to 16. Oh well.
If you put data & xlog on the same array, put them on seperate
partitions, probably formatted differently (ext2 on xlog).
Mike Stone
--
Hi, Richard and Carl,
Richard Huxton wrote:
> Carl Youngblood wrote:
>> - I noticed that there are six different postmaster daemons running.
>> Only one of them is taking up a lot of RAM (1076m virtual and 584m
>> resident). The second one is using 181m resident while the others are
>> less than
Carl Youngblood wrote:
- I noticed that there are six different postmaster daemons running.
Only one of them is taking up a lot of RAM (1076m virtual and 584m
resident). The second one is using 181m resident while the others are
less than 20m each. Is it normal to have multiple postmaster
proce
Well they don't necessarily have the same value!
It's a dictionary with cross-referenced words, e.g. 'bring' and
'brought' are both headwords in the dictionary, but 'brought' is
cross-referenced to 'bring'. So, the table stores the information (using
integer id's rather than words) that
br
Sue Fitt wrote:
Thanks Chris and Chris, you've solved it.
I had a gui open that connects to the database. It was doing nothing
(and not preventing me adding to or altering headwords_core via psql),
but having closed it the table is instantly created. Weird.
BTW, referencing the same column t
Thanks Chris and Chris, you've solved it.
I had a gui open that connects to the database. It was doing nothing
(and not preventing me adding to or altering headwords_core via psql),
but having closed it the table is instantly created. Weird.
BTW, referencing the same column twice is deliberat
Sue Fitt wrote:
Hi all,
This is my first post to the performance list, I hope someone can help me.
I'm setting up a table with 2 columns, both of which reference a column
in another table:
CREATE TABLE headwords_core_lexemes (
core_id int REFERENCES headwords_core(core_id),
lexeme_id int REF
Hi all,
This is my first post to the performance list, I hope someone can help me.
I'm setting up a table with 2 columns, both of which reference a column
in another table:
CREATE TABLE headwords_core_lexemes (
core_id int REFERENCES headwords_core(core_id),
lexeme_id int REFERENCES headwords
Tom Lane napsal(a):
Michal Taborsky - Internet Mall <[EMAIL PROTECTED]> writes:
SELECT product.product_id
FROM action
JOIN product ON (product.product_id=action.product_id)
WHERE action.shop_group_id=1
AND EXISTS (SELECT 1
FROM catalog.product_program
WHERE produc
26 matches
Mail list logo