On Mon, Aug 29, 2011 at 11:21 AM, planas jsloz...@gmail.com wrote:
**
CREATE TABLE *ContactUpdates*
(
VendorID integer NOT NULL,
LastName character varying(45),
FirstName character varying(45),
CONSTRAINT ContactUpdates_pkey PRIMARY KEY (VendorID )
ERROR: relation countupdates
On Thu, Aug 25, 2011 at 11:17 AM, Toby Corkindale
toby.corkind...@strategicdata.com.au wrote:
Do I need to make sure I re-create every index on every child table I
create?
That would be.. annoying, at best.
Is there a way to enable inheritance of indexes too?
You do not need an index on
On Thu, Aug 25, 2011 at 11:57 AM, Toby Corkindale
toby.corkind...@strategicdata.com.au wrote:
It seems messy to inherit the columns but not the indexes or checks upon
them :(
Yes it can be a bit annoying at timse but you can try to automate the whole
process as well. Like I found this blog
On Thu, Aug 25, 2011 at 2:03 PM, Adarsh Sharma adarsh.sha...@orkash.comwrote:
Dear all,
I am using PostgresPlus-8.4SS version of Postgres on Linux Windows
Systems.
Now I need to enable replication of two servers. OS may be same or
different.
Please let me know any useful links to do
the files. Now if we cant have that
shared location and a scenario where all slaves and the master cant see one
shared location, how to approach this?
cheers,
--
Shoaib Mir
http://shoaibmir.wordpress.com/
.
Is this possible/the best solution? Maybe a migration utility would be
better? Suggestions?
Try using SERIAL datatype.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
On Fri, Dec 10, 2010 at 2:53 PM, Shoaib Mir shoaib...@gmail.com wrote:
On Fri, Dec 10, 2010 at 2:44 PM, gvim gvi...@gmail.com wrote:
I'm migrating a database from MySQL and need to keep the original `id`
column (AUTO_INCREMENT) intact so my plan is to create an simple integer
`id` column
On Tue, Nov 9, 2010 at 3:22 PM, Victor Hooi victorh...@yahoo.com wrote:
*4. MS Access to Postgres*
Hmm have you tried Kettle (Pentaho) http://kettle.pentaho.com/
Any particularly good books here that you'd recommend?
http://www.2ndquadrant.com/books/
--
Shoaib Mir
http
be no interruption to the web servers.
I have used Rubyrep for such scenario in the past but that was for a small
database so it didn't give me much trouble.
http://www.rubyrep.org/
--
Shoaib Mir
http://shoaibmir.wordpress.com/
);
--
Shoaib Mir
http://shoaibmir.wordpress.com/
On Fri, Oct 29, 2010 at 3:58 PM, venkat ven.tammin...@gmail.com wrote:
Dear All,
I got the solution... Here is my query
ALTER TABLE DemoTable ALTER gid TYPE INT2;
Are you sure that you have converted here to a SERIAL type?
--
Shoaib Mir
http://shoaibmir.wordpress.com/
in
there.
Shoaib Mir
http://shoaibmir.wordpress.com/
for a short period of time so
that no updates are being performed anywhere.
There is something that I saw the other day in PG 9.0 i.e.
transaction_read_only which might be helpful in your case.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
the new master and have my
replication look like this:
B -- C
B -- A
Where are the steps I need for doing so?
Thanks,
--
Shoaib Mir
http://shoaibmir.wordpress.com/
helpful. But again comparing to other third party solutions it seems just
very simple to setup for replication and sure does work nice. I cant wait
for 9.1 already :)
Regards,
--
Shoaib Mir
http://shoaibmir.wordpress.com/
figure there's a tech
reason for this - the demand must be there! No?
There is one already: https://public.commandprompt.com/projects/plphp
--
Shoaib Mir
http://shoaibmir.wordpress.com/
this in PLPSQL functions myself
--
Shoaib Mir
http://shoaibmir.wordpress.com/
-4ubuntu9) 4.4.1, 32-bit
(1 row)
--
Shoaib Mir
http://shoaibmir.wordpress.com/
of lobj_lock_table?
This is not a PgPool mailing list, please post it to the appropriate list
such as http://lists.pgfoundry.org/pipermail/pgpool-general/
http://lists.pgfoundry.org/pipermail/pgpool-general/
--
Shoaib Mir
http://shoaibmir.wordpress.com/
/43-How-to-install-PostgreSQL-9.0-Beta-1-to-FedoraCentOSRHEL.htmland
see if that fixes the problem.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
and log_statement setting properly in
postgresql.conf so that you get the user info and other appropriate details.
After that you can tail the DB server log file and grep for that specific
user to get what sort of SQL is been executed.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
was running on the system
as well. If you have such installed can you try removing it and then see how
it goes?
--
Shoaib Mir
http://shoaibmir.wordpress.com/
pg_resetxlog to reset the control info on the DB cluster. Once you
have done that try re-starting and hopefully that should work then, but you
will I think lose everything from the last checkpoint by using pg_resetxlog.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
this way you might be able to start the server but you will lose
the data from the time after your last checkpoint.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
in my last email.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
(original,i,1);
END LOOP;
RETURN reverse_str;
END;$_$
LANGUAGE plpgsql IMMUTABLE;
--
Shoaib Mir
http://shoaibmir.wordpress.com/
On Wed, Feb 3, 2010 at 4:14 PM, Scott Frankel fran...@circlesfx.com wrote:
Hi all,
Is it possible to specify a position when adding a column to a table?
Not possible, but have a read of
http://wiki.postgresql.org/wiki/Alter_column_position and look at the
alternative options.
--
Shoaib
start writing my
own log parser?
I am not sure if its still available but there used to a nice tool for doing
the same, I guess it was named as Playr by myyearbook.
Regards,
--
Shoaib Mir
http://shoaibmir.wordpress.com/
(), i, p from prueba limit 5;
--
Shoaib Mir
http://shoaibmir.wordpress.com/
.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
... that might help in this case
--
Shoaib Mir
http://shoaibmir.wordpress.com/
messages:
-
For client programs like psql, change the current locale where you are
starting up psql. I am not sure about windows but in Linux you can do this
by setting LANG environment variable.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
this simple
query? There are about 3 million rows in this table.
Use the *'pgstattuple'* contrib module --
http://www.postgresql.org/docs/current/static/pgstattuple.html
*pgstatindex* function from the contrib module should be able to help you
there.
--
Shoaib Mir
Fujitsu Australia Software
(this will copy pgstattuple.so file to the lib
folder of your PostgreSQL installation)
- Now from psql execute the pgstattuple.sql file for that specific database
which can be found in PG-HOME/share/contrib folder
- Once the sql file is executed now you can use the pgstattuple function
--
Shoaib Mir
Fujitsu
desktop machine, build it and then build the .so file for contrib
module using 'make' and 'make install' once that is done copy the .so
from lib folder of PG to your production PG box's lib folder.
--
Shoaib Mir
Fujitsu Australia Software Technology
[EMAIL PROTECTED]
Try using it with 'execute' as that might help...
OR:
CREATE TEMP TABLE tblname WITH (OIDS) ON COMMIT DROP AS select * from
someothertbl;
that means the temporary table will be dropped at the end of the current
transaction block.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 7/16/07
If you can use tcl based pl function, the this might help you here --
http://sourceforge.net/projects/pgmail/
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 6/20/07, Joshua D. Drake [EMAIL PROTECTED] wrote:
Sean Murphy wrote:
Maybe this is a well duh kind of question, or maybe there's
Something like this will help:
CREATE OR REPLACE FUNCTION import_text_file(char(255)) RETURNS void AS $$
DECLARE
filename ALIAS FOR $1;
fin varchar;
BEGIN
fin := 'COPY table from ' || filename;
execute fin;
END;
$$ LANGUAGE plpgsql;
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com
exceeds work_mem
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 6/11/07, rupesh bajaj [EMAIL PROTECTED] wrote:
Hi,
What is the meaning of 'materializing' a relation after sequential scan?
explain select * from tb1, tb2 where tb1.c1 = tb2.c2;
QUERY PLAN
If you are on 8.1 you can use double qoutes ( 'C:\\Program Files\\My
program' ) on in 8.2 you can use the new backslash_quote (string)
setting.
You can find help on backslash_quote (string) at --
http://www.postgresql.org/docs/current/static/runtime-config-compatible.html
--
Shoaib Mir
Did you do a reload or restart of the server after doing this change?
what do you see when you do this query? -- show log_statement
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 5/29/07, Diego Fernando Arce [EMAIL PROTECTED] wrote:
this is a part of postgrsql.conf
log_statement
in your log file.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.co,)
On 5/29/07, Diego Fernando Arce [EMAIL PROTECTED] wrote:
show log_statement;
log_statement
---
all
(1 fila)
select pg_stat_get_backend_pid(s.backendid),pg_stat_get_backend_activity(
s.backendid) from (select
You can use the MSSQL DTS wizard for that purpose and using PostgreSQL ODBC
connector for target database connectivity there.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 4/5/07, M. Nejat AYDIN [EMAIL PROTECTED] wrote:
How can I migrate data from mssql to postgresql?
I have
I guess shared_buffers (in postgresql.conf file) will help you here if you
have properly setup your kernel.SHMMAX value.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 4/2/07, Sorin N. Ciolofan [EMAIL PROTECTED] wrote:
Hello!
I'd like to ask you if there is any Postgre
Why dont you use the pg_dump (
http://www.postgresql.org/docs/8.2/static/backup-dump.html) utility of
PostgreSQL. Use the -s switch for taking just the schema and -a for taking
the data dumps. Try that and let us know if you face a problem doing so.
--
Shoaib Mir
EnterpriseDB
PostgreSQL documentation for instructions on
this.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 4/2/07, Sorin N. Ciolofan [EMAIL PROTECTED] wrote:
Thanks,
I've a value of 1000 set for shared_buffers, does this means
that I use 8kbX1000=8Mb of Shared Mem
Yes, that is true if you have the autovacuum setting enabled for the
database server. You can see the last auto vacuum and last auto analyze
timestamp values from pg_stat_all_tables.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 3/21/07, Robert James [EMAIL PROTECTED] wrote:
I see
It depends on the amount of memory you have...
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 3/19/07, Ezequias R. da Rocha [EMAIL PROTECTED] wrote:
Hi list,
Could someone tell me the experience of many connections to PostgreSQL ?
I am my afraid if when PostgreSQL have many connections
;
=
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 3/11/07, Shoaib Mir [EMAIL PROTECTED] wrote:
I can see the following in pg_depend:
For view v1:
classid | objid | objsubid | refclassid | refobjid | refobjsubid |
deptype
but cant seem to get a simple output from it which
should be like this:
view_name | dependent_views
v1 |
v2 | v1
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
-++--++--+-+-
_RETURN | 153521 | -1 | 1 | t |
_RETURN | 153524 | -1 | 1 | t |
Right now confused on how do I actually get the dependent views from this
kind of output... any ideas?
--
Shoaib Mir
Try using something like this -- Program Files/PostgreSQL/data (that is
with quotes for using spaces)
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 3/8/07, Steven De Vriendt [EMAIL PROTECTED] wrote:
Hi all,
Got this kind of silly question. I'm trying to use pg_resetxlog.
Problem
log in :)
psql mydb postgres mypwd
That is not the correct way, just as i mentioned change it to md5 and now
when you do
psql -d mydb -U postgres
It will ask for a password.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 3/8/07, George Heller [EMAIL PROTECTED] wrote:
Hi all,
I am
2 | E
3 | C
3 | F
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/13/07, Shane Ambler [EMAIL PROTECTED] wrote:
Ashish Karalkar wrote:
Hello List,
I want to append column of two different tables in a single column of a
view .
data type of tow column of two diffrent tables
So hmm a UNION with an ORDERY BY should be good for this scenario...
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/13/07, Shane Ambler [EMAIL PROTECTED] wrote:
Shoaib Mir wrote:
I guess UNION ALL should work good here instead of a UNION for the exact
same kind of output he needs
or ANALYZE manually and see if that gets
updated in the last_vacuum of pg_stats_all_tables.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/13/07, Walter Vaughan [EMAIL PROTECTED] wrote:
Shoaib Mir wrote:
pg_stat_all_table view should help you:
select last_autovacuum, last_autoanalyze from
pg_stat_all_table view should help you:
select last_autovacuum, last_autoanalyze from pg_stat_all_tables;
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/9/07, Sic Transit Gloria Mundi [EMAIL PROTECTED] wrote:
Hi,
I couldnt find this on google, the archives, or the manual
You can get the details at --
http://www.postgresql.org/docs/8.2/static/backup.html
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/13/07, RPK [EMAIL PROTECTED] wrote:
We are planning a mission-critical client/server application and want to
use
PGSQL as backend to VB.NET. Before
Yes, you can pass values to the scripts. Here is an example
Suppose the script file 'test.sql' is like this:
insert into test values (:chk1 , :chk2);
Now you can pass the variables using psql as:
psql -d test -U postgres -v chk1=5 -v chk2='abc' -f test.sql
Hope that helps...
--
Shoaib
values (1);';
return 1;
end;
$$ LANGUAGE 'plpgsql'
used number by mistake so sorry for any inconvenience caused as I was
trying it with EnterpriseDB (where 'number 'is added for Oracle
compatibility)
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/8/07, Michael Fuhr [EMAIL PROTECTED
Something like this will help you:
execute immediate 'create temporary table test (a number) on commit drop';
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/8/07, Bruno Wolff III [EMAIL PROTECTED] wrote:
On Wed, Feb 07, 2007 at 20:40:09 -0800,
jws [EMAIL PROTECTED] wrote:
Having
There is such timeout from the database server for the idle connections but
yes you can always use firewall settings in order to do that and kill idle
connections.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/6/07, Gurjeet Singh [EMAIL PROTECTED] wrote:
On 1/30/07, Alvaro Herrera
to
see if the db server is running or not. You can do that using:
pg_ctl -D data folder path status
Once that gives a good status then you might have to tweak 'pg_hba.conf'
file to allow for users connecting to the database.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/2/07, gf [EMAIL
a
\df+ add
did show me the correct output...
You can also try the following to get the same type of results:
select proargtypes, prorettype, prosrc from pg_proc where proname =
'delete_old';
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/1/07, Harvey, Allan AC [EMAIL PROTECTED] wrote
commit the client app crashes and the commit is never sent, will the
Exclusive locks be automatically released?
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
Thank you Alvaro :)
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/30/07, Alvaro Herrera [EMAIL PROTECTED] wrote:
Shoaib Mir wrote:
While debugging an application, I just wanted to confirm from the list
here:
Suppose I have a long running transaction which has a few
This might help you:
select encode(col1,'escape') from tblBytea;
where col1 is of type bytea...
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/24/07, marcelo Cortez [EMAIL PROTECTED] wrote:
folks
help me ,i cant read bytea type field's.
how to convert bytea to text
I think the way of doing that will be taking a schema backup using pg_dump
-n option and then restoring that again in the same database using a
different schema name with psql.
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/24/07, johnf [EMAIL PROTECTED] wrote:
Hi,
I
Decode works as expected for me
Try the following:
select decode((encode(E'\\000\\001', 'escape')::text), 'escape');
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/24/07, marcelo Cortez [EMAIL PROTECTED] wrote:
hi Markus ,folks
Are you sure you tested with a real
In order to move data and tables from MS SQL Server to PostgreSQL, use the
MS SQL Server DTS wizard and gave it the ODBC for PostgreSQL as the target
database.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/23/07, Robert Fitzpatrick [EMAIL PROTECTED] wrote:
On Mon, 2007-01
I dont have the replication setup on my machine right now but I guess as far
as I remember you can surely check for the master and slave nodes from a
Slony schema table.
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 19 Jan 2007 08:25:23 -0800, [EMAIL PROTECTED] [EMAIL PROTECTED
should be using varchar(n).
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/20/07, Kelly Burkhart [EMAIL PROTECTED] wrote:
On 1/20/07, Shoaib Mir [EMAIL PROTECTED] wrote:
Should help -- ALTER TABLE tablename ALTER columname TYPE text;
I was looking for a way to alter
the master node goes down.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/19/07, Stéphane Schildknecht [EMAIL PROTECTED]
wrote:
Hello,
You should ask directly to the slony1 mailing list.
[EMAIL PROTECTED] a écrit :
(...) The Slony version I'm using is 1.1.2.
The current
functions.
You can find some good detail over here as well --
http://www.postgresql.org/docs/techdocs.29
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/19/07, Paul Lambert [EMAIL PROTECTED] wrote:
G'day folks,
I'm faily new to the world of Postgre so excuse me
Should help -- ALTER TABLE tablename ALTER columname TYPE text;
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/20/07, Kelly Burkhart [EMAIL PROTECTED] wrote:
On 1/19/07, Martijn van Oosterhout kleptog@svana.org wrote:
ALTER TABLE, to be correct, actually has to check
COPY command might also help
COPY (SELECT * FROM country WHERE country_name LIKE 'A%') TO
'/usr1/proj/bray/sql/a_list_countries.copy';
Details can be found at --
http://www.postgresql.org/docs/current/static/sql-copy.html
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com
You can also opt for partitioning the tables and this way select will only
get the data from the required partition.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/15/07, Richard Huxton dev@archonet.com wrote:
Jan van der Weijde wrote:
Hello all,
one of our customers
Oh yes, need to have a condition first for which you have partitioned
tables. Only in that case it will work with partitions.
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/15/07, Richard Huxton dev@archonet.com wrote:
Shoaib Mir wrote:
You can also opt for partitioning
;
IF v_cnt 0 THEN
v_tbl = 'true';
END IF;
IF v_cnt = 0 THEN
v_tbl = 'false';
END IF;
return v_tbl;
END;
$$ LANGUAGE 'plpgsql'
=
select check_table('emp', 'public');
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/15/07, Alban
If you go with Java, you can make it faster by using setFetchSize (JDBC
functionality) from client and that will help you with the performance in
case of fetching large amounts of data.
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/15/07, Jan van der Weijde [EMAIL
An old post on the archives might help you --
http://archives.postgresql.org/pgsql-interfaces/2005-11/msg00010.php that
was an attempt to simulate functionality similar to setFetchSize in JDBC.
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/15/07, Jan van der Weijde [EMAIL
literals will be processed. The presence
of this parameter can also be taken as an indication that the escape string
syntax (E'...') is supported. Escape string syntax should be used if an
application desires backslashes to be treated as escape characters.
---
Shoaib Mir
EnterpriseDB
You can give EnterpriseDB PL Debugger a try, details for its usage can be
found at -- http://www.enterprisedb.com/documentation/debugger.html
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/14/07, Marcel Gsteiger [EMAIL PROTECTED] wrote:
thanks for responding. Meanwhile I
Can you show us the output for:
ps auxwww | grep ^postgres
that should explain a little more...
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/10/07, Ashish Karalkar [EMAIL PROTECTED] wrote:
Hello All,
I am running PostgresSQL 8.2 on Redhat Linux 4.
When I look
There is no default support but you can always use connectby() function from
the tablefunc contrib module
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/8/07, Leandro Repolho [EMAIL PROTECTED] wrote:
Hello everybody,
In Oracle i use the command connect by prior and i
It is used for Hierarchical queries in Oracle :)
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/8/07, Scott Marlowe [EMAIL PROTECTED] wrote:
On Mon, 2007-01-08 at 07:38, Leandro Repolho wrote:
Hello everybody,
In Oracle i use the command connect by prior and i need
It does install both the Slony binaries and scripts.
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/8/07, Raymond O'Donnell [EMAIL PROTECTED] wrote:
Hello all,
When installing PostgreSQL via the Windows installer, Slony-I is one
of the options offered. Does it install
This should help you get the disk usage for a table:
select pg_size_pretty(pg_relation_size('tablename'));
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/28/06, 马庆 [EMAIL PROTECTED] wrote:
Maybe U can't get the disk usage info, but you can try command explain
-邮件原
Well I haven't use much of PGAdmin but I will always be using pg_dump and
pg_restore for that as they are really easy to use.
You can find help on backup and restore at --
http://www.postgresql.org/docs/8.2/static/backup.html
Shoaib Mir
EnterpriseDB (www.enterprisedb.com
pgpool-II might help you there too I guess...
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/26/06, Andy Dale [EMAIL PROTECTED] wrote:
Hi,
I have just read the statement that Postgres does have (with end user
assembly) multi-master replication system. Is this just
Yes, that is true with pgpool. I did face the same as well.
There is another as well Uni-Cluster (
http://www.continuent.com/index.php?option=com_contenttask=viewid=213Itemid=170),
haven't tried yet but it might help you there...
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com
if that can
work for you, haven't tried that myself but will like to hear about
PostgreSQL configuration with OpenSSI
---
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)
On 12/26/06, Andy Dale [EMAIL PROTECTED] wrote:
The company i am working for has a trail/evaluation license for p
in case of a
master node failure, and then you can actually do the load balancing by
using the slave nodes in the system.
Please let me know on any updates for OpenSSI if you get a chance to try
that out
---
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)
On 12/26/06, Andy Dale [EMAIL
In your SQL script file you can add at the start something like this:
set search_path = contrib
and that should take care of it without this change in psql.
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/23/06, Paul Silveira [EMAIL PROTECTED] wrote:
I was trying
it PostgreSQL on OpenSSI that will be a good info to have.
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/24/06, Lincoln Yeoh lyeoh@pop.jaring.my wrote:
At 08:12 AM 12/22/2006, Joshua D. Drake wrote:
With One Big Database, you can get a SAN and attach a whole lot of
disk
.
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/25/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Thanks Chris,
I see you a core member of Slony team and a replication guru so I'll look
into it.
I'm not slamming Slony I think its probably the right tool for type of
work
your company Afilias
I think you might want to do incremental backups so a better approach to
that as you mentioned too will be WAL files. For details you can refer to
-- http://www.postgresql.org/docs/current/static/continuous-archiving.html
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12
Try increasing the work_mem first to see the change, that might help.
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/24/06, Benjamin Arai [EMAIL PROTECTED] wrote:
I have been running pieces of my PL function by hand and I have found
that the following queries work
adding to the last email, for now try the work_mem but you should be
adding ANALYZE along with the VACUUM (with a cron job I guess) you do
regularly.
Shoaib Mir
EntperpriseDB (www.enterprisedb.com)
On 12/24/06, Shoaib Mir [EMAIL PROTECTED] wrote:
Try increasing the work_mem
Yes, ANALYZE should definitely improve the performance for query...
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/24/06, Benjamin Arai [EMAIL PROTECTED] wrote:
Just to make things more clear I ran EXPLAIN ANALYZE on the slow query.
I got
Merge Full Join (cost=62.33
1 - 100 of 180 matches
Mail list logo
