I have seen that autovacuum takes long time to process .
please give me the reason ..
On Mon, Aug 8, 2011 at 2:10 PM, Tomas Vondra wrote:
> On 8 Srpen 2011, 8:02, Vivekkumar Pandey wrote:
>> Hi ,
>>
>> I have version of PostgreSQL as given below:---
>>
>>
Dear all,
I installed postgresql from a postgresplus-8.4.1-2-linux-x64 binary and
it is working properly in the system.Yesterday i do some work in it.
But today when I restart the system, pgadmin goes missing from
Accessories > .
I don't know the reason of this .Please let me know how to so
On 9 Srpen 2011, 9:18, Vivekkumar Pandey wrote:
> I have seen that autovacuum takes long time to process .
> please give me the reason ..
What do you mean by "takes long time to process"? How do you measure it?
Autovacuum is meant as a background process, and it should run on
background and n
On Mon, Aug 08, 2011 at 10:01:58PM +0200, pasman pasmański wrote:
> Try to change index: objects_endings_tsz_active(state,endings_tsz)
> where state='active'.
adding new indexes on this machine is quite complicated, as it's heavily
used production system.
And the current index should be chosen by
On Tue, Aug 9, 2011 at 2:59 PM, Tomas Vondra wrote:
> On 9 Srpen 2011, 9:18, Vivekkumar Pandey wrote:
>> I have seen that autovacuum takes long time to process .
>> please give me the reason ..
>
> What do you mean by "takes long time to process"? How do you measure it?
>
> Autovacuum is meant
But Can U Please explain in Steps how to solve it.
I mean how to apply patch or anything.
Thanks
Chetan Suttraway wrote:
assuming this is ubuntu, checkout this link:
https://bugs.launchpad.net/unity-2d/+bug/800710
https://bugs.launchpad.net/ubuntu/+source/pgadmin3/+bug/755770
On Tue, Aug 9
On Tuesday, August 09, 2011 2:18:47 am Adarsh Sharma wrote:
> Dear all,
>
> I installed postgresql from a postgresplus-8.4.1-2-linux-x64 binary and
> it is working properly in the system.Yesterday i do some work in it.
>
> But today when I restart the system, pgadmin goes missing from
> Accessor
2011/8/8 Ondrej Ivanič :
> Hi,
>
> 2011/8/9 Merlin Moncure :
>> You have a few of different methods for passing sets between functions.
>
> I do not want to pass data between functions. The ideal solution
> should look like this:
> select * from my_map_func()
well, the method still applies: you'd
Dear Friends,
For client requirements, I am testing postgresql 9.0.4 on windows 7 with
plpython. First I installed python 2.7 and then added python installation
path to windows PATH variable. Then installed postgresql from one-click
installer. Server started and every thing was ok. Then I go to cre
2011/8/8 hubert depesz lubaczewski :
> Hi,
> we have 8.3.11 installation on client site, with table, which looks like
> this:
>
> $ \d objects
> Table "public.objects"
> Column | Type |
> Mo
On Tue, Aug 09, 2011 at 05:11:09PM +0200, Cédric Villemain wrote:
> The plan turn bad without any new ANALYZE, right ?
Right.
> does the table increase more quickly now than before ? is it now way
> larger than before ?
> Also, do you have an explain with the 'good' plan ?
changes in the object
On Mon, Aug 08, 2011 at 10:20:18PM -0400, David Johnston wrote:
>
> >
> > 8.X in this context means "8 point something, but I can't recall
> > which something". Could be 8.2, 8.3 or 8.4. Thus, in effect, asking
> > those replying to restrict themselves to 8 series features, as
> > opposed to 9 s
hubert depesz lubaczewski writes:
> as for good plan. sure. If i'll disable bitmap scans, I get:
> $ explain analyze select count(*) from objects where state='active' and
> ending_tsz <= (select now() - '1 day'::interval );
>
Paul M Foster writes:
> It'd be great if select pg_version() worked, but PG doesn't recognize
> the function, when issued from the PG prompt.
It's "select version()".
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
On Tue, Aug 09, 2011 at 12:11:48PM -0400, Tom Lane wrote:
> Now part of the reason why the estimate is so bad is the sub-select,
> which completely defeats selectivity estimation for the ending_tsz
> condition. Could we see EXPLAIN ANALYZE for the query without a
> sub-select, both with and withou
On Tue, Aug 9, 2011 at 7:54 AM, c k wrote:
> Dear Friends,
> For client requirements, I am testing postgresql 9.0.4 on windows 7 with
> plpython. First I installed python 2.7 and then added python installation
> path to windows PATH variable. Then installed postgresql from one-click
> installer.
On Tue, Aug 09, 2011 at 12:11:48PM -0400, Tom Lane wrote:
> There's absolutely no hope of getting the planner to make intelligent
> plan choices when its estimates are that far off (3344138 rows estimated
> versus none actual). It's just luck if you get the "right" plan despite
> that.
> Now part
hubert depesz lubaczewski writes:
> version with disabled bitmapscans:
> $ explain analyze select count(*) from objects where state='active' and
> ending_tsz <= now() - '1 day'::interval;
> QUERY PLAN
> -
On Mon, Aug 8, 2011 at 8:14 AM, sameera vhora wrote:
> We are facing below issue after creating slony replication of
> partitioning table in edb server 8.3.
>
> This issue persist only on slave one not the primary one.
>
> Below logs we found in tomcats.
>
>
> Error in postgresql driver initia
On Tue, Aug 09, 2011 at 04:08:39PM -0400, Tom Lane wrote:
> I suppose what's going on here is that the "state" and "ending_tsz"
> columns are highly correlated, such that there are lots of 'active'
> items but hardly any of them ended more than a day ago? If so,
yes, that's correct.
> you're goi
hubert depesz lubaczewski writes:
> I solved the problem by adding "enable_bitmapscan = false" (and keeping
> the query in original format, with subselect) which caused the plan to
> be ok.
I doubt that solution is any more robust than what you had before ---
in particular, it's likely to fall ba
Hi,
According to the docs, the DEFAULT keyword lets you explicitly insert a
field's default value in an INSERT statement.
>From a db function, I'd like to force the use of default when an input
parameter is null. This syntax looks correct but fails to compile.
Any suggestions?
INSERT INTO publ
Hi,
I'm about to evaluate this SSD card: FusionIO ioDrive Duo [1]. The
main reason for this experiment is to see if SSD can significantly
improve query performance. So, I have the following questions:
- Could you please share your experience with SSD? Any issues?
- What needs to be changed at Pos
Hi, when posting SQL it may be a good practice to post your PG
version so that answers may be more accurate and better fit your
needs. In this case, I don't think you'll be able to do what you are
trying to, because as of my understanding the "DEFAULT" is not part of
an expression but a keyword i
Thanks for the previous posts. I am in fact running 9.0 'nix and am unable
to find a way to embed DEFAULT within an expression.
I can always rewrite the function to call EXECUTE but that's not a very good
solution in this case because many of our db functions are code generated.
On Tue, Aug 9, 201
This is a bit hacky, but it may work (I haven't tried it yet). If it
works let us know and if it doesn't then maybe we can debug it and get
something useful, or move on to another solution.
INSERT INTO public.test
(
userid, object_id, user_notes, object_status, created_ts
)
VALUES
(
p_userid, p_
Good idea but you're right, if the default value is an expression such as a
the next serial value, it will need to be executed first. If Execute
doesn't return the interpreted value, I don't know of a way to make it
work..
On Tue, Aug 9, 2011 at 5:35 PM, Diego Augusto Molina <
diegoaugustomol...@
Here is the actual function.
create or replace function software.python_test() returns text as
$body$
import sys
from uuid import getnode as get_mac
mac = get_mac()
return mac
$body$
language plpythonu volatile security definer;
When running the same code from python prompt, it run correctly witho
On 9/08/2011 10:54 PM, c k wrote:
Normal python functions returning text etc. are working but when conatining
import sys
from uuid import getnode as get_mac
mac = get_mac()
return mac
fails. What will be the reason?
You still haven't supplied the error message you get when you run this.
In
29 matches
Mail list logo
