Hi,
We got a corrupted database server, and I need some advice on what else
can I do.
Specs:
- Postgres 8.3.3 @ Linux dbserver4 2.6.24-etchnhalf.1-686-bigmem
- 4 GB RAM
- PGDATA with 700GB (70GB used), software RAID-0 with 3 sata-2
(blame it on me, ugh...)
So, the steps till now:
1 - Vacuum
André Volpato escreveu:
10. Same error
# psql matriz
psql: FATAL: could not read block 0 of relation 1664/0/2676: read
only 0 of 8192 bytes
Right now this is the message I got every time I try to connect, even
in single mode.
We tried to fsck the raid partition, but with no luck.
Hope
Tom Lane escreveu:
=?ISO-8859-1?Q?Andr=E9_Volpato?= [EMAIL PROTECTED] writes:
8. Postgres is up, but...
# psql matriz
psql: FATAL: could not read block 0 of relation 1664/0/2676: read only
0 of 8192 bytes
Looks like your raid array is dying under you :-( ...
We hope it last more 3
Andrus escreveu:
snip
SELECT * FROM invoices WHERE invoiceno IN ( '1,3,4' );
but this causes error.
snip
change it to ( '1','3','4' ) or ( 1,3,4 )
--
ACV
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
.
Sure, there is a rownum() implementation from depesz [1] that works nice
for reports.
[1]
http://www.depesz.com/index.php/2007/08/17/rownum-anyone-cumulative-sum-in-one-query/
--
André Volpato
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
. :)
Try out JPivot too, Mondrian will give you MDX support, an JPivot is
like a web frontend.
Follow the instructions here [1] and good luck.
[1] http://mondrian.pentaho.org/documentation/installation.php
--
[]´s,
André Volpato
Ecom Tecnologia LTDA - Análise e Desenvolvimento
[EMAIL PROTECTED
Gregory Stark escreveu:
André Volpato [EMAIL PROTECTED] writes:
I think I found the answer!
8.1: likes nested loop even after vacuumdb on the database.br
8.3: likes hash at first time but:
- after vacuumdb *on the database* (I was running on the tables.), it turns
out to:
Merge Join
be rewritten for 8.3)
2. Vacuum is up2date!
3. Is there any way to make [2] use the index ?
--
[]´s,
André Volpato
Ecom Tecnologia LTDA - Análise e Desenvolvimento
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: In versions below 8.0
Gregory Stark escreveu:
André Volpato [EMAIL PROTECTED] writes:
And the query:
# select j.i, t.t from jtest j inner join test t on t.i = j.i where (j.i*1.5)
between 300 and 400;
Planner for [1]:
Nested Loop (cost=0.00..270192.02 rows=2 width=41) (actual
Planner for [2
this tests I disabled autovacuum, and run vacuum analyze test /
jtest before.
--
[]´s,
André Volpato
Ecom Tecnologia LTDA - Análise e Desenvolvimento
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send
Tom Lane escreveu:
Gregory Stark [EMAIL PROTECTED] writes:
But I'm curious if you turn off mergejoin whether you can get a Nested Loop
plan and what cost 8.3 gives it. It looks to me like 8.3 came up with a higher
cost for Nested Loop than 8.1.9 (I think 8.1.10 came out with some
, you show the desired html.
--
[]´s,
André Volpato
Ecom Tecnologia LTDA - Análise e Desenvolvimento
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
Reid Thompson escreveu:
On Tue, 2007-11-06 at 14:39 -0300, André Volpato wrote:
Remember that you can always use serial fields to count a table, like:
alter table foo add id serial;
select id from foo order by id desc limit 1;
This should return the same value than count
Richard Huxton escreveu:
Reg Me Please wrote:
While I would not spend resources in fine tuning the count(*), I would
spend some to underastand why and how the other ones do it better.
Just to be better.
The problem is well understood, and there is extensive discussion in
the mailing lists
Hi all,
I´m experiencing an unexpected behaviour in the planner. I want the
planner to apply a function in the results of a subquery, but its doing
a filter in the hole table.
The results between the mixed filters are the same in the end, but its
taking ages. What I want is the planner to
Alvaro Herrera escreveu:
test tester escribi:
On 10/4/07, test tester [EMAIL PROTECTED] wrote:
i have version 8.1 and i want to know how to insert multiple rows in this
version.
Upgrade.
Use COPY instead.
Put you data into a var, and
Mike Ginsburg escreveu:
Hello,
I am working on a personnel registry that has upwards of 50,000
registrants. Currently I am working on an export module that will
create a CSV from multiple tables. I have managed to keep the script
(PHP) under the memory limit
okay... some info needed
Mike Ginsburg escreveu:
André Volpato wrote:
Mike Ginsburg escreveu:
Hello,
I am working on a personnel registry that has upwards of 50,000
registrants. Currently I am working on an export module that will
create a CSV from multiple tables. I have managed to keep the
script (PHP) under
Alvaro Herrera escreveu:
Mike Ginsburg wrote:
Hello,
I am working on a personnel registry that has upwards of 50,000
registrants. Currently I am working on an export module that will create a
CSV from multiple tables. I have managed to keep the script (PHP) under
the memory
Hello,
I need constraint definitions like pg_indexes.indexdef , in order to
drop / create them on the fly.
BTW, where can I find a complete doc about Postgres Metadata ?
- AV
---(end of broadcast)---
TIP 1: if posting/reading through Usenet,
Decibel! escreveu:
On Wed, Aug 08, 2007 at 08:56:47AM -0300, Andr? Volpato wrote:
Hello everybody,
Im working with a small project to a client, using Postgres to
store data in a dimensional model, fact-oriented, e.g., a Datamart.
At this time, all I have is a populated database,
Hello
everybody,
Im working with a small project to a client, using Postgres to store
data in a dimensional model, fact-oriented, e.g., a Datamart.
At this time, all I have is a populated database, with the "star
schemma" common relations (PKs / FKs).
Below is a list of the main goals of
, 300 columns per table)
Joins are done in the form of Left joins (sometimes on the same tables,
due to normalisation)
Is 30min - 2hours too long or is this considered normal??
What do you mean for 'Datawarehouse queries' ?
Is there any OLAP server between youp app and Postrgres?
--
[]´s,
André
Hello,
I need to store one-length values like '1', '2', '3' or '4' .
Today, this field is indexed with btree and is of type smallint (int2).
How much performance will be improved if I change it to char (1 byte
length) ? Or int2 is the best solution in this case ?
Thanks !
--
[]´s,
André
Tom Lane escreveu:
=?ISO-8859-1?Q?Andr=E9_Volpato?= [EMAIL PROTECTED] writes:
I need to store one-length values like '1', '2', '3' or '4' .
Today, this field is indexed with btree and is of type smallint (int2).
How much performance will be improved if I
André Volpato escreveu:
Tom Lane escreveu:
=?ISO-8859-1?Q?Andr=E9_Volpato?= [EMAIL PROTECTED] writes:
I need to store one-length values like '1', '2', '3' or '4' .
Today, this field is indexed with btree and is of type smallint (int2).
How much performance will be improved if I
not
'forget' the results of any query until the cache reach 2 Gb (total box
RAM) , or the server is rebooted.
--
[]´s,
André Volpato
ECOM Tecnologia Ltda
[EMAIL PROTECTED]
(41) 3014 2322
---(end of broadcast)---
TIP 5: don't forget to increase your
27 matches
Mail list logo