On Thursday, April 11, 2013, X.H.WANG <82661...@qq.com> wrote:
> Hello everybody:
>
> After I switch the slave to the master , I can not get the stats
> information by the below sql and the pg_stat_reset() does not work on the
> New Master,
> And I vacuum by hand,it's still not work! I ne
On Wed, Apr 10, 2013 at 10:10 AM, Vedran Krivokuca wrote:
> On Wed, Apr 10, 2013 at 9:07 AM, Vedran Krivokuca
> wrote:
> > 1) we can go with different instances of PostgreSQL service, let's say
> > (for pure theory) 10 of them on the same HA cluster setup. Every
> > instance would hold let's say
something like this would probably work too
for a in `echo "SELECT p.proname
FROM pg_catalog.pg_proc p
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE pg_catalog.pg_function_is_visible(p.oid)
AND n.nspname <> 'pg_catalog'
AND n.nspname <> 'information_schema'"|psql -A -t test`;
The size of your directory will increase by 16mb on every checkpoint (16Mb
or 5 mins) so, even if your DB is completely idle you will get 16Mb per 5
mins, make the calculations and you'll see the space you need per day.
Vasilis Ventirozos
On Thu, Mar 28, 2013 at 8:54 AM, Hoàng Thanh Toàn
7;"|psql -A -t test`;
do echo "SELECT pg_get_functiondef('$a'::regproc);"|psql -A -t test
>$a.function.sql ;done
Worked for me, will give you one file per function , called
functionname.function.sql
i just wrote it so i haven't test it much
Vasilis Ve
an unlogged table will be truncated at database restart in case of a crash
or unclean shutdown, could that be the case ?
Vasilis Ventirozos
On Wed, Mar 13, 2013 at 7:36 PM, "Gabriel E. Sánchez Martínez" <
gabrielesanc...@gmail.com> wrote:
> I have run into an annoying
resembles subjects seen on
some viruses.]
On Mon, May 09, 2005 at 02:06:46PM +0300, Vasilis Ventirozos wrote:
hi all i created a function that restarts the server, i will show you
what i am doing
The trigger function you posted is called whenever you insert a
record into the favorites table
hi all i created a function that restarts the server, i will show you
what i am doing
drop trigger lala_trig on favorites;
drop function fav_funct() cascade;
create or replace function fav_funct() returns trigger AS '
declare
old_id int default 0;
new_id int default 0;
rec record;
rec2 record;
re
Hi all
i sow that in postgres 7.4.x set autocommit to off is not supported
but as i was searching in web i saw :
" If you prefer autocommit-off, you may wish to set it in your
.psqlrc file."
How can i do that ?
Thanx
Vasilis Ventirozos
---(end of
loged in
Thanx in advance
Vasilis Ventirozos
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Thursday 25 September 2003 12:01, you wrote:
> Hi ,
>
> I would appreciate if some one could help me how to take a sin
pg_dump -t tablename dbname
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
I have some Gigs of useless transaction logs from databases that i have
created-droped etc..
can i recycle the logs or i have to run initdb again ?
Vasilis Ventirozos
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL
Try loading the data first and then create the indexes i recently loaded 50
Million rows in a table much bigger and it took about 1hour including the
creation of indexes .
Vasilis Ventirozos
---(end of broadcast)---
TIP 7: don't forg
The Server is a dual Xeon 2.4 HP with a 15k rpm scsi disk and 2 Gigz of ram
# Connection Parameters
#
tcpip_socket = true
#ssl = false
#max_connections = 32
#superuser_reserved_connections = 2
port = 5432
#hostname_lookup = false
#show_source_port = false
#unix_socket_directory =
I use the default comfiguration file with the tcpip enabled
any sagestion about the configuration file ?
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
This is a simple statement that i run
core_netfon=# EXPLAIN select spcode,count(*) from callticket group by spcode;
QUERY PLAN
---
Aggregate (cost=2057275.91..2130712.22 rows
it's not a stadard statement, i am tring to get statistics for the company and
i see a lack of performance (the same statement on informix runs good with
the same indexes of course)
Vasilis Ventirozos
---(end of broadcast)---
TIP 8: ex
ave a huge database to ask him some issues ?
my hardware is good ,my indexes are good plz dont answer me something like use
vacuum :)
The Joy of Index
Vasilis Ventirozos
---(end of broadcast)---
TIP 8: explain analyze is your friend
18 matches
Mail list logo
