Alvaro Herrera wrote:
> Alvaro Herrera wrote:
>
>>> How much is the age decremented by on a vacuum run then?
>> It should be decremented to the vacuum_freeze_min_age. However, I'm
>> running some experiments with your settings and apparently it's not
>> working as it should.
>
Okay, if it's dec
Alvaro Herrera wrote:
> Bruce McAlister wrote:
>> Alvaro Herrera wrote:
>>> Bruce McAlister wrote:
>>>
>>> Ok now this is interesting:
>>>
select datname, age(datfrozenxid) from pg_database;
datname |age
-+---
blueface-crm
Eddy D. Sanchez wrote:
Hello Everyone.
I want to scan a large quantity of books and documents and store these
like images, I want use postgres, anyone have experience with this kind
of systems, can you suggest me an opensource solution ??
Why do you want to use a database rather than just st
"Luki Rustianto" <[EMAIL PROTECTED]> writes:
> I've found on pg7.4.x that plpgsql trigger will not wait for finishing
> one line of command before executing to the next line, specially if
> that command is firing another trigger on another table. This is very
> wrong on my point of view. This only
Michael Glaesemann <[EMAIL PROTECTED]> writes:
> On Jun 27, 2007, at 18:18 , Keary Suska wrote:
>> Is it possible to have a user-defined function (a plpqsql function)
>> as the
>> argument to a default clause that issues SELECTs on other tables?
> Not according to the documentation:
> http://www
Hi All,
I've found on pg7.4.x that plpgsql trigger will not wait for finishing
one line of command before executing to the next line, specially if
that command is firing another trigger on another table. This is very
wrong on my point of view. This only happen on pg7. To check:
(create master and
Tomasz Rakowski wrote:
I see autovacuum process starting in avarage every 5 minutes
(table contains 30.000 records, and update rate is about 1000records /min).
But what is strange is that the number of pages allocated to the table
are constant (at least for this hour: 500)
and number of pa
Paul Lambert wrote:
> Looks like my bad - I created the table initially through pgAdminIII and
> it appears I selected the wrong character varying from the dropdown list.
>
> CREATE TABLE tester
> (
> test_varchar character varying[],
> test_text text
> )
>
> If I change it to character va
Michael Glaesemann wrote:
Works for me:
test=# select version();
version
--
PostgreSQL
Paul Lambert wrote:
> Is there any disk space advantages to using varchar over text? Or will a
> text field only ever use up as much data as it needs.
1. no 2. yes.
--
Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 18.1", W 73º 13' 56.4"
"Hackers share the surgeon's secret pleasure in
On Jun 27, 2007, at 19:38 , Paul Lambert wrote:
Is there any disk space advantages to using varchar over text?
No.
Or will a text field only ever use up as much data as it needs.
Yes.
From http://www.postgresql.org/docs/8.2/interactive/datatype-
character.html
The storage requirement
So, I wrote myself a trigger function that when called will
dynamically create new partition tables and rules so that the first
new record for each partition creates the partition. The only bit that
I wanted to see if there was a a better solution was the actual insert
into the new table at the en
"Brian J. Erickson" <[EMAIL PROTECTED]> writes:
> I get the following message in the "pgstartup.log":
> postmaster cannot access the server configuration file
> "/database/postgresql.conf": Permission denied
Are you trying to change the standard config file location on a
Red Hat or Fedora system?
Tom Lane wrote:
"Pierre Thibaudeau" <[EMAIL PROTECTED]> writes:
I am puzzling over this issue:
1) Is there ever ANY reason to prefer "varchar(n)" to "text" as a column type?
In words of one syllable: no.
Not unless you have an application requirement for a specific maximum
length limit (eg
yay its fixed. How do I make the topic solved?
Danyelle
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Jun 27, 2007, at 18:18 , Keary Suska wrote:
Is it possible to have a user-defined function (a plpqsql function)
as the
argument to a default clause that issues SELECTs on other tables?
Not according to the documentation:
http://www.postgresql.org/docs/8.2/interactive/sql-createtable.htm
Hello Everyone.
I want to scan a large quantity of books and documents and store
these like images, I want use postgres, anyone have experience with
this kind of systems, can you suggest me an opensource solution ??
Thanks.
---(end of broadcast)--
Is it possible to have a user-defined function (a plpqsql function) as the
argument to a default clause that issues SELECTs on other tables?
Thanks,
Keary Suska
Esoteritech, Inc.
"Demystifying technology for your home or business"
---(end of broadcast)--
Yes,
That was the odd thing about it. All I did was add the ip address. I
will have to change my postgres password cause I can't remember it.
bleh..
---(end of broadcast)---
TIP 6: explain analyze is your friend
Alvaro,
I see autovacuum process starting in avarage every 5 minutes
(table contains 30.000 records, and update rate is about 1000records /min).
But what is strange is that the number of pages allocated to the table are
constant (at least for this hour: 500)
and number of pages allocated
Tomasz Rakowski wrote:
> Alvaro,
>
> I changed autovacuum parametrs for this specific table in pg_autovacuum
>
> insert into pg_autovacuum(vacrelid,enabled,vac_base_thresh,
> vac_scale_factor, anl_base_thresh, anl_scale_factor,
> vac_cost_dela
Alvaro Herrera wrote:
> > How much is the age decremented by on a vacuum run then?
>
> It should be decremented to the vacuum_freeze_min_age. However, I'm
> running some experiments with your settings and apparently it's not
> working as it should.
Nah, false alarm, it's working as expected for
Alvaro,
I changed autovacuum parametrs for this specific table in pg_autovacuum
insert into pg_autovacuum(vacrelid,enabled,vac_base_thresh,
vac_scale_factor, anl_base_thresh, anl_scale_factor,
vac_cost_delay, vac_cost_limit,
freeze_min_age, f
On 6/28/07, Danyelle Gragsone <[EMAIL PROTECTED]> wrote:
Now all I have to do is figure out how to login. My old username and
password no longer works..
So you were able to connect to the database with webmin
before this change? In that case you may want a similar
line for your own user accoun
Amazing how one little line.. makes everything sad.
Now all I have to do is figure out how to login. My old username and
password no longer works..
thanks for helping!
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
On Jun 27, 2007, at 16:17 , Richard Broersma Jr wrote:
--- Osvaldo Rosario Kussama <[EMAIL PROTECTED]> wrote:
Try:
SELECT your_field ~ '.*[[:digit:]]{2}$';
This could be simplified a little. :o)
WHERE your_field ~ '\\d{2}$';
Using dollar-quotes means not having to escape your \d (which I
Tomasz Rakowski wrote:
> Matthew,
>
> Thank you for reply.
>
> I was trying to configure autovacuum for given table to be more aggressive
> (min=100, scale factor=0.01).
> Then waited for autovacuum to be activated for given table
> (watching Server status window; about 1000 updates/mi
Bruce McAlister wrote:
> Alvaro Herrera wrote:
> > Bruce McAlister wrote:
> >
> > Ok now this is interesting:
> >
> >> select datname, age(datfrozenxid) from pg_database;
> >> datname |age
> >> -+---
> >> blueface-crm| 441746613
>
Hi all.
I understand this can be a ridiculous question for most you.
The very same query on the very same db shows very variable timings.
I'm the only one client on an unpupolated server so I'd expect a
rather constant timing.
INstead for a while the query become very slooow and the CPU reached
On 6/28/07, Danyelle Gragsone <[EMAIL PROTECTED]> wrote:
Here is the entire file.
Could someone please take a look at this and tell me what I am doing
wrong. Apparently I have something commented that I shouldn't but I
don't know what that is. Sorry if I sound like a complete moron.. but
I a
Here is the entire file.
# PostgreSQL Client Authentication Configuration File
# ===
#
# Refer to the PostgreSQL Administrator's Guide, chapter "Client
# Authentication" for a complete description. A short synopsis
# follows.
#
# This file control
Matthew,
Thank you for reply.
I was trying to configure autovacuum for given table to be more aggressive
(min=100, scale factor=0.01).
Then waited for autovacuum to be activated for given table
(watching Server status window; about 1000 updates/min, 30.000 rows in the
table, so didn't
Alvaro Herrera wrote:
> Bruce McAlister wrote:
>
> Ok now this is interesting:
>
>> select datname, age(datfrozenxid) from pg_database;
>> datname |age
>> -+---
>> blueface-crm| 441746613
>
> Note this value is 440 million, and yo
--- Osvaldo Rosario Kussama <[EMAIL PROTECTED]> wrote:
> Try:
> SELECT your_field ~ '.*[[:digit:]]{2}$';
This could be simplified a little. :o)
WHERE your_field ~ '\\d{2}$';
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will i
On 6/28/07, Danyelle Gragsone <[EMAIL PROTECTED]> wrote:
BEFORE
# TYPE DATABASEUSERCIDR-ADDRESS METHOD
#"local" is for Unix domain socket connections only
host template1 postfix, postfixadmin all 10.2.0.202 255.255.255.0 trust
# IPv4 local connections:
hostall
Hello,
I get the following message in the "pgstartup.log":
postmaster cannot access the server configuration file
"/database/postgresql.conf": Permission denied
I have:
1) read the file doing the following:
a) su posgres
b) less postgresql.conf
2) made sure each directory to file is read
Warren escreveu:
I need to check if the last two characters of a field are a number. I am
trying something like this but it does not want to work.
substring(TRIM(field8) from '..$') SIMILAR TO '\d\d'
How should I do this?
Try:
SELECT your_field ~ '.*[[:digit:]]{2}$';
Osvaldo
BEFORE
# TYPE DATABASEUSERCIDR-ADDRESS METHOD
#"local" is for Unix domain socket connections only
host template1 postfix, postfixadmin all 10.2.0.202 255.255.255.0 trust
# IPv4 local connections:
hostall all 127.0.0.1/32 trust
# IPv6 local conn
Thanks Alvaro,
Your information proved very handy.
~Jas
On 6/27/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
Jasbinder Singh Bali escribió:
> Hi,
> i have a column in my table defined like this:
>
> time_stamp timestamp DEFAULT ('now'::text)::timestamp with time zone
Note that the column is o
On 6/28/07, Danyelle Gragsone <[EMAIL PROTECTED]> wrote:
I am sorry William but you lost me. I haven't disabled anything have I?
Hard to say w/o seeing the WHOLE file. You're looking in the
wrong section.
What you need to make sure is that the line William posted
*isn't* commented out.
Chee
Bret Busby wrote:
What is happening (or not happening) with pgaccess?
As far as I know pgaccess has been dead for years. I would suggest
www.pgadmin.org
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergen
Bruce McAlister wrote:
Ok now this is interesting:
> select datname, age(datfrozenxid) from pg_database;
> datname |age
> -+---
> blueface-crm| 441746613
Note this value is 440 million, and you said in your original report that
>
Well, for Ruby there are two Postgres drivers, a native compiled one I
run in Linux, and a pure Ruby one that I use in Windows. The PGconn
object in the Windows version doesn't seem to offer the methods putline,
readline or endcopy. The Linux version does, but since I do development
in both Lin
What is happening (or not happening) with pgaccess?
In upgrading a computer from Debian Linux 3.1 (sarge) to Debian Linux
4.0 (etch), the package pgaccess is no longer available.
My wife has it installed on her Ubuntu system, which is the version
before the current one. However, the pgaccess
...As we continue through this process I just want to express my sincere thanks
for your suggestions heretofore
I use neither RedHat nor Fedora :( I also didn't look carefully at the RPMs you
were offering me. They are for XML::LibXSLT, not LibXSLT. Sorry about that!
I originally built XML:
On Wed, Jun 27, 2007 at 02:54:05PM -0400, Jaime Silvela wrote:
> The problem is that the getline/readline interface, which does exist for
> Ruby, doesn't seem to work so well, and anyway operates line by line; I
> would have preferred to just hand a file descriptor and be done with it.
Hrm, in w
Jasbinder Singh Bali escribió:
> Hi,
> i have a column in my table defined like this:
>
> time_stamp timestamp DEFAULT ('now'::text)::timestamp with time zone
Note that the column is of type timestamp, which _doesn't_ have a time
zone. You probably want
time_stamp timestamp with time zone DEFAU
Hi,
Il giorno 27/giu/07, alle ore 20:54, Jaime Silvela ha scritto:
The problem is that the getline/readline interface, which does
exist for Ruby, doesn't seem to work so well, and anyway operates
line by line; I would have preferred to just hand a file descriptor
and be done with it.
Tha
Hi,
i have a column in my table defined like this:
time_stamp timestamp DEFAULT ('now'::text)::timestamp with time zone
Data gets filled in this column from a Unix tools server.
Example values of this field are:
time_stamp
2007-06-27 14:52:14.760133
The problem is that the getline/readline interface, which does exist for
Ruby, doesn't seem to work so well, and anyway operates line by line; I
would have preferred to just hand a file descriptor and be done with it.
Thanks for your suggestions too, Erik and Ted. Performance-wise the best
sol
yes..go with the specific distro for your OS (either RH or Fedora)
keep us apprised!
Thanks/
M--
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom this email message is
addressed. If you have received this email message
I compiled the libraries from the source tarballs I configured using
--with-crypt --with-debugger --with-python. It is always possible I missed
something!
Do you think the RPMs will even be applicable considering I'm not using RedHat
or Fedora?
- Original Message
From: Martin Gai
On 27.06.2007 15:18, Albe Laurenz wrote:
Hannes Dorbath wrote:
What would be a solution to prevent a single user/schema to fill the
disk using PostgreSQL? Is it a good idea to use separate table spaces?
Table spaces are the only solution I can think of.
If you create a table space on a differe
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Warren
> Sent: Wednesday, June 27, 2007 12:31 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Checking for a number
>
> I need to check if the last two characters of a field ar
I need to check if the last two characters of a field are a number. I am
trying something like this but it does not want to work.
substring(TRIM(field8) from '..$') SIMILAR TO '\d\d'
How should I do this?
--
Thanks,
Warren Bell
---(end of broadcast)---
Tomasz Rakowski wrote:
I have problem with frequently updated table (around 30.000 records and
1000 updates/minute, few indexes).
After a while all queries to that table become much slower then at the
begining
(the number of records in the table is quite stable all the time).
I can see that a
Hi CG
looks as if your 64bit box needs 64bit libraries instead of default 32 bit
did you check here
http://dries.studentenweb.org/apt/packages/perl-XML-LibXSLT/info.html
Let us know
M--
This email message and any files transmitted with it contain confidential
information intended only for the
On Wed, Jun 27, 2007 at 10:32:32AM -0400, Jaime Silvela wrote:
> I've been looking around for this functionality:
> Is it possible to use COPY with a file that doesn't reside in the DB's
> filesystem? I know there is sort of a solution in using COPY from stdin/
> COPY to stdout, however that depe
Postgresql 8.1
I made a simple modification to contrib/xml2 to include the ability to process
exslt tags... On the production side, the postmaster crashes when I try to
process my exslt stylesheet. On my development machine, everything runs without
crashing. There's a number of differences ther
On Jun 27, 2007, at 9:32 AM, Jaime Silvela wrote:
I've been looking around for this functionality:
Is it possible to use COPY with a file that doesn't reside in the
DB's filesystem? I know there is sort of a solution in using COPY
from stdin/ COPY to stdout, however that depends on calling
Hi everybody,
I have problem with frequently updated table (around 30.000 records and 1000
updates/minute, few indexes).
After a while all queries to that table become much slower then at the begining
(the number of records in the table is quite stable all the time).
I can see that autovacuum
I just checked the manual and it says nothing about being able to use the SQL
copy to access network files.
But you have an option that almost works for you. I am sure others here will
have some suggestions, but if I were in your place, I'd gather more information
about where bottleneck
On 27.06.2007 16:58, Dawid Kuroczko wrote:
On 6/27/07, Hannes Dorbath <[EMAIL PROTECTED]> wrote:
What would be a solution to prevent a single user/schema to fill the
disk using PostgreSQL? Is it a good idea to use separate table spaces?
I am contemplating using XFS filesystem's quota to achiev
I am sorry William but you lost me. I haven't disabled anything have I?
On 6/27/07, William Leite Araújo <[EMAIL PROTECTED]> wrote:
2007/6/27, Danyelle Gragsone <[EMAIL PROTECTED]>:
> Greetings,
>
> I am trying to setup postgres and postfix using webmin. I am
> following this guide:
>
http://g
On 6/27/07, Hannes Dorbath <[EMAIL PROTECTED]> wrote:
What would be a solution to prevent a single user/schema to fill the
disk using PostgreSQL? Is it a good idea to use separate table spaces?
I am afraid currently you are stuck with tablespaces as a quoting tool.
Of course having a filesyste
I've been looking around for this functionality:
Is it possible to use COPY with a file that doesn't reside in the DB's
filesystem? I know there is sort of a solution in using COPY from stdin/
COPY to stdout, however that depends on calling the psql command, which
breaks the flow of control of
Hannes Dorbath wrote:
>
> What would be a solution to prevent a single user/schema to fill the
> disk using PostgreSQL? Is it a good idea to use separate table spaces?
Table spaces are the only solution I can think of.
If you create a table space on a different file system, then a table in
that
The work-around for old Slony versions:
replication_wait() {
echo "Waiting for all slaves are in sync with the master...";
echo "
`slonik_print_preamble`
# Hack for old Slony: this is a dummy operator which generates a
SYNC
# event and saves its ID for later waiting o
2007/6/27, Danyelle Gragsone <[EMAIL PROTECTED]>:
Greetings,
I am trying to setup postgres and postfix using webmin. I am
following this guide:
http://gentoo-wiki.com/HOWTO_Email:_A_Complete_Virtual_System_-_Postfix_to_Postgres
I received the following in the postgres db section of webmin:
s
Hi everybody,
I could not find any information on the passing arrays to the dblink
remote call.
By now I am using something like:
select t.r from dblink( connection_name, 'select r from
remote_stored_procedure( ARRAY[' || array_to_string( my_id_array,
',' ) || '] )' ) as t(r text);
The construc
Ashish Karalkar wrote:
Thnkas Richard for your replay.
Actually ,I was looking for some setting in postgresql.conf file
Is there any one?
Not to run at just a specific time.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 2: Don'
Thnkas Richard for your replay.
Actually ,I was looking for some setting in postgresql.conf file
Is there any one?
With Regards
Ashish
- Original Message -
From: "Richard Huxton" <[EMAIL PROTECTED]>
To: "Ashish Karalkar" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, June 27, 2007 1:00 PM
Su
Greetings,
I am trying to setup postgres and postfix using webmin. I am
following this guide:
http://gentoo-wiki.com/HOWTO_Email:_A_Complete_Virtual_System_-_Postfix_to_Postgres
I received the following in the postgres db section of webmin:
select * from pg_database order by datname failed : no
What would be a solution to prevent a single user/schema to fill the
disk using PostgreSQL? Is it a good idea to use separate table spaces?
--
Regards,
Hannes Dorbath
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore y
On Wed, Jun 27, 2007 at 09:28:24AM +1200, Martin Langhoff wrote:
> Alvaro Herrera wrote:
> > I think it would be much easier if you did something like
> >
> > select * from test where lower(to_ascii(value)) = lower(to_ascii('martín'));
> >
> > When to_ascii doesn't work (for example because it do
Ashish Karalkar wrote:
Hello all,
I want to set Auto vaccunme in such a way that it will start in the Mid night
(12:00 A.M.)
Is there any way to do this except Cron Job for Linux
What's wrong with "cron"? It's the tool that's designed to run timed jobs.
--
Richard Huxton
Archonet Ltd
--
Try and remember to CC: the list - there are plenty of other people who
can help too.
chandresh rana wrote:
Hi Richard,
Let me explain you exactly what am trying to achieve.
Am trying to export the database of the sever(ver 7.4) to my local
server(ver 8.2).The problem in exporting ,is that c
Alvaro Herrera wrote:
> Bruce McAlister wrote:
>
>> I have just checked the pg_stat_all_tables in the pg_catalog schema and
>> I can see the index scans etc table values incrementing. The data in the
>> tables seems to be updating. Just an FYI, I've enabled manual vacuum
>> analyze runs on the blu
Hello all,
I want to set Auto vaccunme in such a way that it will start in the Mid night
(12:00 A.M.)
Is there any way to do this except Cron Job for Linux
Thanks In advance
With Regards
ashish ...
79 matches
Mail list logo
