>>From your earlier problem description you seem to be attempting to run
> two databases on one server. That requires a custom install, though even
> if you did this it definitely would not provide you with any of the
> outcomes you might want to create:
>
> Are you trying to
> a) run a backup with
Hi Everyone.
Is there any function in postgresql7.1.3 to convert unix time stamp to
normal date and time format
Regards
J Mageshwaran
** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to
Sify Limited and is intended for use only by the ind
Hi!
I eventually tried with an 'vacuum analyse' which made postgres to use my index
and the query was completed in 200 ms (insted of tens of seconds) and I was
happy again!
Thanks!
/Rickard
Citerar Tom Lane <[EMAIL PROTECTED]>:
> Rickard =?iso-8859-1?b?U2r2c3Ry9m0=?=
> <[EMAIL PROTECTED]> wr
Arnau <[EMAIL PROTECTED]> writes:
>Lets say that in my database I have a view named foo_view and I'd
> like to dump it's definition. I'd like to do something like:
> pg_dump --view=foo_view bar_db > foo_view.log
-t works fine on views...
regards, tom lane
--
Rickard =?iso-8859-1?b?U2r2c3Ry9m0=?= <[EMAIL PROTECTED]> writes:
> fast db:
> -
> -> Index Scan using testcase_b_bid_index on testcase (cost=0.00..1656.82
> rows=426 width=38) (never executed)"
> -
> slow db:
> -
> -> Se
There is also a add on in contrib (pg_buffercache) that can be used to
give an indication of the number of buffers in use, this can be used to
help find a 'good' shared mem size for your configuration.
David.
---(end of broadcast)---
TIP 6: expla
In response to "Sorin N. Ciolofan" <[EMAIL PROTECTED]>:
>
> I've a value of 1000 set for shared_buffers, does this means
> that I use 8kbX1000=8Mb of Shared Mem?
>
>
>
> The definition from the manual is quite confusing:
>
>
>
> shared_buffers (integer)
>
> Sets th
On 4/2/07, Rickard Sjöström <[EMAIL PROTECTED]> wrote:
Hi!
This post is related to the post "Performance of views" but this is another
problem now.
Problem: PostgreSQL seems to not use my index.
My postgres is 7.4.
I started all over again and got my query really fast on one database (~40
se
An extract from --> http://www.powerpostgresql.com/PerfList/ might help
you
shared_buffers:
As a reminder: This figure is NOT the total memory PostgreSQL has to work
with. It is the block of dedicated memory PostgreSQL uses for active
operations, and should be a minority of your total RAM on
Thanks,
I've a value of 1000 set for shared_buffers, does this means
that I use 8kbX1000=8Mb of Shared Mem?
The definition from the manual is quite confusing:
shared_buffers (integer)
Sets the amount of memory the database server uses for shared
You can use the following query to get all the views:
select 'CREATE VIEW '||viewname||' AS '||definition as viewSQL from pg_views
where schemaname='';
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 4/2/07, Arnau <[EMAIL PROTECTED]> wrote:
Hi all,
Lets say that in my database I have
Hi all,
Lets say that in my database I have a view named foo_view and I'd
like to dump it's definition. I'd like to do something like:
pg_dump --view=foo_view bar_db > foo_view.log
so I'd have in the foo_view.log file the foo_view's definition. This
same concept I'm searching to apply it to
Hi!
This post is related to the post "Performance of views" but this is another
problem now.
Problem: PostgreSQL seems to not use my index.
My postgres is 7.4.
I started all over again and got my query really fast on one database (~40
seconds became 150 ms). BUT when trying on another db (sam
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 configura
First of all run the VACUUM FULL ANALYZE and that should hopefully help you
get rid of this problem without changing the max_fsm_pages. Other then this
I will recommend you to have the autovacuuming process in place for proper
database maintenance.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com
It seems to be what occurred : the windows client crashed ...
Still, it's a bit of a problem to have a filesystem full in a matter of
minutes just because a client machine crashed while having an SSL connection
opened on the postgresql server...
On Thursday 29 March 2007 19:40:18 Peter Koczan wr
http://www.postgresql.org/docs/8.1/interactive/kernel-resources.html
On 4/2/07, Sorin N. Ciolofan <[EMAIL PROTECTED]> wrote:
Hello!
I'd like to ask you if there is any Postgre configuration parameter (like
the ones defined in postgresql.conf file) that could be used for increasing
the
Hello!
I'd like to ask you if there is any Postgre configuration parameter (like
the ones defined in postgresql.conf file) that could be used for increasing
the shared memory for Postgre?
Thank you very much
With best regards,
Sorin
18 matches
Mail list logo
