Dear all,
I am researched a lot about Performance tuning in Pgsql.
I found that we have to change shared_buffer parameter and
effective_cache_size parameter.
I changed shared_buffer to 2 GB but I can't able to locate
effective_cache_size parameter in postgresql.conf file.
Also i want to chan
On 12/09/10 7:36 PM, gvim 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 the `id`
column, import the data then convert the new `id` column to a
SEQUENCE. Is this possible/the best solution? Maybe a migration
I'm migrating a database from MySQL and need to keep the original `id` column
(AUTO_INCREMENT) intact so my plan is to create the `id` column, import the
data then convert the new `id` column to a SEQUENCE. Is this possible/the best
solution? Maybe a migration utility would be better? Suggestio
Got the link.
http://wiki.postgresql.org/wiki/FAQ#What_is_the_maximum_size_for_a_row.2C_a_table.2C_and_a_database.3F
--
Thanks & Regards
DJ
From: Jaiswal Dhaval Sudhirkumar
Sent: Thu 12/9/2010 10:07 PM
To: Jaiswal Dhaval Sudhirkumar; pgsql-general@postgresql.
On Fri, Dec 10, 2010 at 2:53 PM, Shoaib Mir wrote:
>
>
> On Fri, Dec 10, 2010 at 2:44 PM, gvim 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, import the data then conve
On Fri, Dec 10, 2010 at 2:44 PM, gvim 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, import the data then convert the new `id` column to a SEQUENCE.
> Is this possible/the be
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,
import the data then convert the new `id` column to a SEQUENCE. Is this
possible/the best solution? Maybe a migration utility would be bet
On Fri, Dec 10, 2010 at 1:24 AM, Gabi Julien wrote:
> On Wednesday 08 December 2010 21:58:46 you wrote:
>> On Thu, Dec 9, 2010 at 1:37 AM, Gabi Julien
>> wrote:
>> > slave# /etc/init.d/postgresql start
>> > slave# psql -hlocalhost my_db -c "select pg_last_xact_replay_timestamp(),
>> > now() as
I am getting the following error when trying to migrate a db from
8.4.0/FreeBSD 7.1 to 9.0.1/FreeBSD 8.1, both are VMware virtual machines
with FreeBSD amd64...
data1# psql -U pgsql template1 < /data/maia.sql
template1 < /data/incoming.sql
ERROR: invalid byte sequence for encoding "UTF8": 0x
On Thu, Dec 9, 2010 at 5:25 AM, Paul Taylor wrote:
> Hi, Im using Postgres 8.3 on a Macbook Pro Labtop.
> I using the database with just one db connection to build a lucene search
> index from some of the data, and Im trying to improve performance. The key
> thing is that I'm only a single user bu
On 09/12/2010 15:51, t...@fuzzy.cz wrote:
Hi, Im using Postgres 8.3 on a Macbook Pro Labtop.
I using the database with just one db connection to build a lucene
search index from some of the data, and Im trying to improve
performance. The key thing is that I'm only a single user but
manipulating l
On Thursday, December 9, 2010, Raimon Fernandez wrote:
>
> On 9dic, 2010, at 04:40 , Raimon Fernandez wrote:
>
>> Hello,
>>
>> I have to audit all the changes for all rows of one database.
>>
>> I have a trigger that executes BEFORE any update or delete, and simply copy
>> the row (INSERT INTO) i
On Thu, Dec 9, 2010 at 8:37 AM, Jaiswal Dhaval Sudhirkumar
wrote:
> How can I measure the approximate database size based on raw* data.
> Is there any calculation template?
>
> --
> Thanks & Regards
> DJ
One option:
select pg_size_pretty( pg_database_size( 'yourdatabase' ) );
--
Sent via pgsql-
Hi all,
I'm wondering if there's an accepted way to monitor a warm standby
machine's lag in 8.4. The wiki[1] has a link[2] to a script which
parses the output of pg_controldata, looking for a line like this:
Time of latest checkpoint:Thu 09 Dec 2010 01:35:46 PM EST
But I'm not sure
Hey Harald -
The permissions! Of course! Thanks, you fixed me.
Brady
On Wed, Dec 8, 2010 at 6:18 AM, Massa, Harald Armin wrote:
> Brady,
>
> Then I attempted to mount a normal encrypted volume with TrueCrypt, move
>> the data\ and sub-folders to this volume and reconfigure PG to point to thi
Hey general@,
To be assured and just for calmness.
Problem:
1. CREATE TABLE test_tab (id integer, dat varchar(64));
2. INSERT INTO test_tab VALUES($1, $2) via PQexecParams,
where paramTypes[0] == OID of bigint,
paramTypes[1] == OID of text.
Questions:
Whether this case falls to
ht
On 12/09/2010 12:36 PM, Paul Taylor wrote:
> On 09/12/2010 15:12, Reid Thompson wrote:
>> On 12/09/2010 09:59 AM, Andy Colson wrote:
>>> On 12/9/2010 8:50 AM, Andy Colson wrote:
On 12/9/2010 6:25 AM, Paul Taylor wrote:
You need to bump up your SHMMAX is your OS.
>>> sorry: SHMMAX _in_ you
On 09/12/2010 15:12, Reid Thompson wrote:
On 12/09/2010 09:59 AM, Andy Colson wrote:
On 12/9/2010 8:50 AM, Andy Colson wrote:
On 12/9/2010 6:25 AM, Paul Taylor wrote:
You need to bump up your SHMMAX is your OS.
sorry: SHMMAX _in_ your OS.
its an OS setting not a PG one.
-Andy
scroll down
On 9dic, 2010, at 04:40 , Raimon Fernandez wrote:
> Hello,
>
> I have to audit all the changes for all rows of one database.
>
> I have a trigger that executes BEFORE any update or delete, and simply copy
> the row (INSERT INTO) into the replicated table.
>
> For example, every table has the
Ignore the previous mail.
How can I measure the approximate database size based on raw* data.
Is there any calculation template?
--
Thanks & Regards
DJ
--
Thanks & Regards
Dhaval Jaiswal | Technical Specialist - Database | Microland Limited
Fax: +91 80 4328 0044. Cell: +91 80953.978.43
www.mic
How can I measure the approximate database size based on row data.
Is there any calculation template?
--
Thanks & Regards
DJ
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material.
Any review, re-tra
On Wednesday 08 December 2010 21:58:46 you wrote:
> On Thu, Dec 9, 2010 at 1:37 AM, Gabi Julien wrote:
> > slave# /etc/init.d/postgresql start
> > slave# psql -hlocalhost my_db -c "select pg_last_xact_replay_timestamp(),
> > now() as not_modified_since;"
> > pg_last_xact_replay_timestamp |
On 9dic, 2010, at 14:32 , Vick Khera wrote:
>> well, after a VACUUM things are going faster ... I'm still trying to analyze
>> the function as it seems there are other bottlechecnk, but at least the
>> first update now is faster as before ...
>>
>
> If that's the case then your 'no' answer to
> Hi, Im using Postgres 8.3 on a Macbook Pro Labtop.
> I using the database with just one db connection to build a lucene
> search index from some of the data, and Im trying to improve
> performance. The key thing is that I'm only a single user but
> manipulating large amounts of data , i.e process
Hi there,
First: I must say thanks to authors of this two posts:
http://blog.endpoint.com/2010/09/reducing-bloat-without-locking.html
and
http://www.depesz.com/index.php/2010/10/17/reduce-bloat-of-table-without-longexclusive-locks/
These two posts was provided me exellent ideas and starting point
Hi, Im using Postgres 8.3 on a Macbook Pro Labtop.
I using the database with just one db connection to build a lucene
search index from some of the data, and Im trying to improve
performance. The key thing is that I'm only a single user but
manipulating large amounts of data , i.e processing ta
On Wed, Dec 8, 2010 at 10:58 PM, Raimon Fernandez wrote:
> well, after a VACUUM things are going faster ... I'm still trying to analyze
> the function as it seems there are other bottlechecnk, but at least the first
> update now is faster as before ...
>
If that's the case then your 'no' answer
On 12/09/2010 09:59 AM, Andy Colson wrote:
> On 12/9/2010 8:50 AM, Andy Colson wrote:
>> On 12/9/2010 6:25 AM, Paul Taylor wrote:
>> You need to bump up your SHMMAX is your OS.
>
> sorry: SHMMAX _in_ your OS.
>
> its an OS setting not a PG one.
>
> -Andy
>
>
scroll down to the section on OSX
On 12/9/2010 8:50 AM, Andy Colson wrote:
On 12/9/2010 6:25 AM, Paul Taylor wrote:
Hi, Im using Postgres 8.3 on a Macbook Pro Labtop.
I using the database with just one db connection to build a lucene
search index from some of the data, and Im trying to improve
performance. The key thing is that
On 12/9/2010 6:25 AM, Paul Taylor wrote:
Hi, Im using Postgres 8.3 on a Macbook Pro Labtop.
I using the database with just one db connection to build a lucene
search index from some of the data, and Im trying to improve
performance. The key thing is that I'm only a single user but
manipulating la
I am preparing an installation disk for a customer. Their installation
includes over ten scheduled jobs. The only way I know of to create a
job is through PGAdmin, using a wizard to enter each piece of
information one screen at a time. I don't want to have to prepare an
instruction document that
Hi, Im using Postgres 8.3 on a Macbook Pro Labtop.
I using the database with just one db connection to build a lucene
search index from some of the data, and Im trying to improve
performance. The key thing is that I'm only a single user but
manipulating large amounts of data , i.e processing ta
Hello
2010/12/9 AI Rumman :
> A simple query I can write in any of the following two ways:
> 1.
> Select col1
> from table
> where col2 in ('A','B');
> 2.
> Select col1
> from table
> where
> col2 = 'A'
> or col2 = 'B'
> Here IN condition may be more than two.
> I need to know which one is good
A simple query I can write in any of the following two ways:
1.
Select col1
from table
where col2 in ('A','B');
2.
Select col1
from table
where
col2 = 'A'
or col2 = 'B'
Here IN condition may be more than two.
I need to know which one is good for good performance.
Any idea please.
Kalai this is not the proper list to ask, in my opinion. And sincerely I
don't know if a proer list exists.
What you want to achieve is to build a web application and the most
followed way to do that is to use a web framework.
Web frameworks are software that allows you build a web application,
lik
35 matches
Mail list logo
