max_fsm_pages

Cross compile of Postgresql

Cross Compile

Re: Cross Compile

MicazMAK <emoazzam <at> yahoo.com> writes:
>   I am trying to cross compile postgresql for ARM platform. I am configure it on my linux enironment.
Configure is done without any errors but when I make it gives me error like cannot execute binary file.

Offhand I'd think that "make" should work but "make install" would have
a problem because it tries to run "zic" which will have been built for
the target platform.  The easiest solution might be to copy over zic
and the timezone data files, and do that step on the target.  Or you
could recompile zic for the source platform (it doesn't need to get
installed).

If that's not it, you need to provide more details.

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Increasing the shared memory

Re: Increasing the shared memory

http://www.postgresql.org/docs/8.1/interactive/kernel-resources.html

On 4/2/07, Sorin N. Ciolofan <ciolofan <at> ics.forth.gr> 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 shared memory for Postgre?
>
>
>
> Thank you very much
>
> With best regards,
>
> Sorin

--

-- 
marius <at> {bsd.com.ro, joy2share.com, vrajamarii.net, ispot.ro}

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Re: SSL broken pipe

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 wrote:
> I saw this on one of my servers a few weeks ago (it was running
> postgres 7.4under linux, and I believe the users in question were just
> running psql). I
> talked to someone more knowledgeable about SSL about this, and he said that
> these errors are usually due to some abrupt disconnection somewhere (in any
> application, not just postgres). My best guess is that the connection was
> broken while data was trying to be fed, causing the server to say "Hey,
> where'd you go?...Here's your data again...Hey where'd you go?..." ad
> infinitum.
>
> Other than that, I have no idea what would cause this or how to fix it
> short of restarting the postgres server or rebooting the machine.
>
> That being said, I don't know a whole lot about SSL, and people with more
> knowledge are more than welcome to weigh in.
>
> Peter
>

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate

Re: max_fsm_pages

Re: Increasing the shared memory

PG does not use my index

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 (same postgres server but with approx. 4 times as much data) it was really slow again
(say 10 seconds). 

Then I run the EXPLAIN ANALYSE of a sub-query of my query which I realize was the problem. 

It seems that it does not make use of the index in the slower database!?

fast db:
-------------------------
 ->  Index Scan using testcase_b_bid_index on testcase  (cost=0.00..1656.82 rows=426 width=38) (never executed)"
-------------------------

slow db:
-------------------------
->  Seq Scan on testcase  (cost=0.00..2896.42 rows=33242 width=64) (actual time=77.027..791.014
rows=37093 loops=1)"
-------------------------

rows=37093 is all of the existing rows of table testcase!
(why does it say "never executed"?)

Any ideas why it does not use my index??? How can I convince it to do so?

/Rickard

Citerar Tom Lane <tgl <at> sss.pgh.pa.us>:

> Rickard =?iso-8859-1?b?U2r2c3Ry9m0=?=
> <rickard.sjostrom <at> bluebottle.com> writes:
> > I have a view that is really slow and I ca easily work around the
> slowness by bypassing the view and query the real table directly.
> 
> Let's see the exact definition of the view and EXPLAIN ANALYZE
> results
> for doing it both ways.  Also, what PG version is this?
> 
> 			regards, tom lane
>

----------------------------------------------------------------------
Need cash? Click to get an emergency loan, bad credit ok
http://tags.bluebottle.com/fc/CAaCMPJe8z3dVmZgRfajsIJMkopwDwDI/

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate