On Tue, 20 Oct 2009, Ow Mun Heng wrote:
Raid10 is supposed to be able to withstand up to 2 drive failures if the
failures are from different sides of the mirror. Right now, I'm not
sure which drive belongs to which. How do I determine that? Does it
depend on the output of /prod/mdstat and in
On Wed, Oct 21, 2009 at 12:10 AM, Greg Smith gsm...@gregsmith.com wrote:
On Tue, 20 Oct 2009, Ow Mun Heng wrote:
Raid10 is supposed to be able to withstand up to 2 drive failures if the
failures are from different sides of the mirror. Right now, I'm not sure
which drive belongs to which. How
On Tue, 20 Oct 2009, Craig Ringer wrote:
You made an exact image of each drive onto new, spare drives with `dd'
or a similar disk imaging tool before trying ANYTHING, right? Otherwise,
you may well have made things worse, particularly since you've tried to
resync the array. Even if the data
On Wed, 21 Oct 2009, Scott Marlowe wrote:
Actually, later models of linux have a direct RAID-10 level built in.
I haven't used it. Not sure how it would look in /proc/mdstat either.
I think I actively block memory of that because the UI on it is so cryptic
and it's been historically much
InterRob a écrit :
Arnaud Lesauvage a écrit :
Also, doing a search like :
SELECT * FROM mytable WHERE upper(myflied) ILIKE u'%c29f%';
Gives me 0 result.
Am I wrong to think that the error 'character 0xc29f of UTF8' relates
to the character with code point C29F in UTF8 ?
I would do this
I tried Power Architect for about 5 minutes, just enough time to
notice it had no support for UUIDs which makes it all but useless.. I
mean, seriously who doesn't use UUIDs :)
Maybe they'll fix that, it does look promising..
Search the archives this came up within the last couple of months.
The problem is how you use those data ?
I have used schemas to split data when I had to manage large amount of
data (hundred of thousand records) that are (almost) never going to be
used together, if not for statistic purposes and offline processing.
If you never need to select those data all
I need to create a pl/pgsql function witch accept a list of parameters and
evaluate them.
I've tried this
CREATE OR REPLACE FUNCTION get_first_valid (lista_elementi VARCHAR[])
RETURNS VARCHAR AS $$
DECLARE
the_oneVARCHAR;
BEGIN
IF (ARRAY_UPPER(lista_elementi, 1) IS NOT
Hi Thom,
Sorry for the delay, I got sick in the meantime. I see that others
already did some review, I will do a quick one too, later maybe I'll
actually try it out... so after a quick review:
* on line 218, the ENCODING '$DBname') part feels wrong, you probably
want hardcoded UTF8 encoding
-Original Message-
From: Greg Smith [mailto:gsm...@gregsmith.com]
On Wed, 21 Oct 2009, Scott Marlowe wrote:
Actually, later models of linux have a direct RAID-10 level built in.
I haven't used it. Not sure how it would look in /proc/mdstat either.
I think I actively block memory of
2009/10/21 Csaba Nagy n...@ecircle-ag.com:
Hi Thom,
Sorry for the delay, I got sick in the meantime. I see that others
already did some review, I will do a quick one too, later maybe I'll
actually try it out... so after a quick review:
* on line 218, the ENCODING '$DBname') part feels
I know that postgresql array implementation is not right complete and that if
just
one element of array is NULL the basics array function (array_dims,
array_upper, etc.) returns NULL.
I need to send a list of parameters (which could contain NULL values) and
evaluate the parameters
Hi, All
Well what do we have?
8 core, 32 GB, RAID 10, CentOS 5.2, Pg 8.3
A query using tsearch in WHERE block with ORDER and LIMIT:
select * from test_table where obj_tsvector @@
make_tsquery('some_words', 'utf8_russian') and obj_status_did = 1
order by obj_created desc limit 10;
Two indexes -
Hi All,
I am doing a fulltext search something like this:
SELECT doc_id FROM docs WHERE tsv_title($$'magnetic induction'$$) OR
tsv_body($$'magnetic induction'$$) OR tsv_abstract($$'abstract'$$)
It is taking approximately 100 secs to execute.
But running the query on individual column something
Can we have a explain plan SELECT doc_id FROM docs WHERE tsv_title($$'magnetic
induction'$$) OR
tsv_body($$'magnetic induction'$$) OR tsv_abstract($$'abstract'$$)
--
Thanks
Sam
--- On Wed, 21/10/09, Gaini Rajeshwar raja.rajeshwar2...@gmail.com wrote:
From: Gaini Rajeshwar
Also OR operator taking time.
--- On Wed, 21/10/09, Gaini Rajeshwar raja.rajeshwar2...@gmail.com wrote:
From: Gaini Rajeshwar raja.rajeshwar2...@gmail.com
Subject: [GENERAL] How to use Logical Operators in Fulltext Search?
To: pgsql-general@postgresql.org mailing list
Sergey Konoplev gray...@gmail.com writes:
Is there a way (or workaround) to make it use i_test_table__created
for frequent and i_test_table__tsvector_1 for sparse words?
You would need to update to 8.4 for that --- 8.3 does not have any
support for statistics estimation for @@.
(Whether 8.4
Gaini Rajeshwar raja.rajeshwar2...@gmail.com writes:
I am doing a fulltext search something like this:
SELECT doc_id FROM docs WHERE tsv_title($$'magnetic induction'$$) OR
tsv_body($$'magnetic induction'$$) OR tsv_abstract($$'abstract'$$)
Since you haven't told us what those functions do,
Pavel Stehule pavel.steh...@gmail.com writes:
I know that postgresql array implementation is not right complete and that
if just
one element of array is NULL the basics array function (array_dims,
array_upper, etc.) returns NULL.
It's not true. Dimensions are stored independent to content.
Dear All,
Kindly clarify that whether PostgreSQL 8.4.1 is supported on RHEL 4 and RHEL
5.2, and what type of installation binaries are available ( RPM etc) for it.
Also can I upgrade the Postgresql 7.4.6-1 to PostgreSQL 8.4.1.
Regards,
Utsav Turray
Disclaimer :- This e-mail and any attachment
Tatsuo Ishii is...@postgresql.org wrote:
Hi,
While attending a Linux conference, a guy said that 10,923 lines of
code are added and 5,547 lines of code are deleted per day in average
in Linux development. This is an interesting number and I just wonder
anybody ever tries to calculate these
On Wed, Oct 21, 2009 at 12:37 AM, Pavel Stehule pavel.steh...@gmail.com wrote:
2009/10/21 Merlin Moncure mmonc...@gmail.com:
On Tue, Oct 20, 2009 at 5:12 PM, Pavel Stehule pavel.steh...@gmail.com
wrote:
[ shrug... ] There are other possible reasons why the planner would
fail to flatten a
Hello to all,
I have been using Talend now for a few months and am very happy with the
software. I have seen on the website
(http://www.talend.com/partners/index.php ) the page on the Talend
certification and the exam.
I'm pretty curious to see what it takes to take the exam, if you need to
On Tuesday 20 October 2009 10:05:34 pm Roderick A. Anderson wrote:
John wrote:
Hi,
Is it better to create multi databases or create multi schemas?
John, I just gave a talk on multi-tenant Pg clusters at PgConf West
2009 that may help you but ran into vehicle problems and just got home
On Wednesday 21 October 2009 01:23:18 am Ivano Luberti wrote:
The problem is how you use those data ?
I have used schemas to split data when I had to manage large amount of
data (hundred of thousand records) that are (almost) never going to be
used together, if not for statistic purposes and
Dear PG community,
I would like to know if anyone there is using pgsphere ( v 1.1.0) with PG
v 8.3.6 , I have few questions regarding the compatibility of this 2
versions.
Thank you,
Isabella
--
View this message in context:
10/21/2009 08:40 AM, Tatsuo Ishii:
Does anyone know such number?
With some script binding the PG SCM you could easily find that.
It's all about SUMming -- and ++ from commit diffs.
--
Architecte Informatique chez Blueline/Gulfsat:
Administration Systeme, Recherche Developpement
On Wed, 2009-10-21 at 14:43 +0530, utsav wrote:
Kindly clarify that whether PostgreSQL 8.4.1 is supported on RHEL 4
and RHEL 5.2, and what type of installation binaries are available
( RPM etc) for it.
Per http://yum.pgsqlrpms.org/rpmchart.php , both distros are supported.
RPMs are available
Hi,
I have one of my database server that I run the "top" command:
top - 16:16:30 up 42 days,
13:23, 4 users, load average: 3.13, 3.52, 3.36
Tasks: 624 total, 1 running, 623 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.4%us, 1.1%sy, 0.0%ni, 84.4%id, 12.9%wa, 0.0%hi, 0.2%si,
0.0%st
Mem: 16432240k
Hi,
I have one of my database server that I run the top command:
top - 16:16:30 up 42 days, 13:23, 4 users, load average: 3.13, 3.52, 3.36
Tasks: 624 total, 1 running, 623 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.4%us, 1.1%sy, 0.0%ni, 84.4%id, 12.9%wa, 0.0%hi, 0.2%si,
0.0%st
Mem:
On Wed, 21 Oct 2009, Waldomiro wrote:
I'm afraid of two things, one is the load average, I think 3 is too
much, another is the swap, almost 4GB of swap, I think that is too much
swap.
Am I right?
Not necessarily.
Can I use those indicators to know if my database is ok?
Perhaps.
On Wed, 2009-10-21 at 14:40 +0900, Tatsuo Ishii wrote:
While attending a Linux conference, a guy said that 10,923 lines of
code are added and 5,547 lines of code are deleted per day in average
in Linux development. This is an interesting number and I just wonder
anybody ever tries to calculate
Waldomiro wrote:
Hi,
I have one of my database server that I run the top command:
top - 16:16:30 up 42 days, 13:23, 4 users, load average: 3.13, 3.52,
3.36
Tasks: 624 total, 1 running, 623 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.4%us, 1.1%sy, 0.0%ni, 84.4%id, 12.9%wa, 0.0%hi,
Greetings!
PostgreSQL just crashed on a client's machine. There are several strange
things in the log file for today. Among the strangest is the following:
2009-10-21 12:28:01 EDT anneal 94S-CAPS1.akst.com ERROR: syntax error at or
near qecr at character 2
2009-10-21 12:28:01 EDT anneal
Radcon Entec wrote:
Greetings!
PostgreSQL just crashed on a client's machine. There are several
strange things in the log file for today. Among the strangest is the
following:
2009-10-21 12:28:01 EDT anneal 94S-CAPS1.akst.com ERROR: syntax error
at or near qecr at character 2
I've put the English schedule (Désolé utilisateurs Français) on a
calendar for my own use, but made it public in case anyone else might
find it helpful, like syncing it with a mobile device etc:
XML:
On Wed, Oct 21, 2009 at 12:43 PM, Waldomiro waldom...@shx.com.br wrote:
Hi,
I have one of my database server that I run the top command:
top - 16:16:30 up 42 days, 13:23, 4 users, load average: 3.13, 3.52, 3.36
Tasks: 624 total, 1 running, 623 sleeping, 0 stopped, 0 zombie
Cpu(s):
As a followup to my previous post, here's what a healthy, well behaved
but running under moderate load db server looks like:
top - 15:47:51 up 436 days, 2:31, 3 users, load average: 12.03, 11.86, 12.26
Tasks: 394 total, 7 running, 387 sleeping, 0 stopped, 0 zombie
Cpu(s): 17.3%us,
On Wed, 21 Oct 2009, Waldomiro wrote:
top - 16:16:30 up 42 days, 13:23, 4 users, load average: 3.13, 3.52, 3.36
Cpu(s): 1.4%us, 1.1%sy, 0.0%ni, 84.4%id, 12.9%wa, 0.0%hi, 0.2%si, 0.0%st
Mem: 16432240k total, 16344596k used, 87644k free, 27548k buffers
Swap: 10241428k total,
On Wed, Oct 21, 2009 at 4:01 PM, Greg Smith gsm...@gregsmith.com wrote:
On Wed, 21 Oct 2009, Waldomiro wrote:
top - 16:16:30 up 42 days, 13:23, 4 users, load average: 3.13, 3.52,
3.36
Cpu(s): 1.4%us, 1.1%sy, 0.0%ni, 84.4%id, 12.9%wa, 0.0%hi, 0.2%si,
0.0%st
Mem: 16432240k total,
Scott Marlowe scott.marl...@gmail.com writes:
In this:
Mem: 16432240k total, 16344596k used,87644k free,27548k buffers
Swap: 10241428k total, 3680860k used, 6560568k free, 6230376k cached
The 6.2G cached is considered part of the 16G used
So it's not using more memory than it
On Wed, 21 Oct 2009, Scott Marlowe wrote:
In this:
Mem: 16432240k total, 16344596k used,87644k free,27548k buffers
Swap: 10241428k total, 3680860k used, 6560568k free, 6230376k cached
The 6.2G cached is considered part of the 16G used
So it's not using more memory than it has.
On Wed, Oct 21, 2009 at 4:25 PM, Greg Smith gsm...@gregsmith.com wrote:
On Wed, 21 Oct 2009, Scott Marlowe wrote:
In this:
Mem: 16432240k total, 16344596k used, 87644k free, 27548k buffers
Swap: 10241428k total, 3680860k used, 6560568k free, 6230376k cached
The 6.2G cached is
Sim Zacks wrote:
I'm using 8.2.4
Numeric with scale precision always shows the trailing zeros.
Numeric plain only shows numbers after the decimal point that are being
used.
I would like to have the data in my table with scale and precision, but
my views to be cast to numeric without any
Hi,
after a computer crash my postgres 8.2.14 installation under Windows XP
SP3 doesn't start anymore. Here is the log file:
C:\Dokumente und Einstellungen\Admin2009-10-21 23:57:09 LOG: database
system was interrupted while in recovery at 2009-10-21 22:21:14
2009-10-21 23:57:09 HINT: This
If I have a table with fields A, B, C and D how could I do something
such that if I insert values in fields A, B and C field D would be
auto-filled with the value A||B||C? Just a pointer of where to begin
looking is fine. Triggers? Copy ... From? Table or field definitions?
thx
--
Sent via
On Wed, Oct 21, 2009 at 07:17:44PM -0700, semi-ambivalent wrote:
If I have a table with fields A, B, C and D how could I do something
such that if I insert values in fields A, B and C field D would be
auto-filled with the value A||B||C? Just a pointer of where to begin
looking is fine.
2009/10/21 Patrick Brückner payda...@gmail.com:
Hi,
after a computer crash my postgres 8.2.14 installation under Windows XP SP3
doesn't start anymore. Here is the log file:
2009-10-21 23:57:10 FATAL: could not count blocks of relation
1663/68065/68157: Permission denied
I assume it has
Hey Folks,
I want to run a warm standby scenario by you. I'm pretty sure it'll
work, but it's a very large database so even the slightest mistake can
mean a major setback.
Scenario:
Server A is the provider node, shipping WAL files to Server B. Server
B is destined to become the
This seems like a simple question that would have come up, but I'm not
able to find an answer in google, PG docs, or PG mailing list archives.
How do I prevent a user from being able to list all databases in my
cluster? I want to restrict them to seeing just the databases they have
connect
Below are the options that you can use to create user and assign them
privileges according to your environment.
Command: CREATE USER
Description: define a new database role
Syntax:
CREATE USER name [ [ WITH ] option [ ... ] ]
where option can be:
SUPERUSER | NOSUPERUSER
|
Did you find what the reason of crash was?
Log seems that the data is corrupted as the system was
crashed. Smart way it to reload data from the valid backup and start your work.
If you don’t have a valid backup then at last touch the file (68157) and try to
restart your db.
--
Thanks
Sam
Adam Rich wrote:
This seems like a simple question that would have come up, but I'm not
able to find an answer in google, PG docs, or PG mailing list archives.
How do I prevent a user from being able to list all databases in my
cluster? I want to restrict them to seeing just the databases
53 matches
Mail list logo