Re: [GENERAL] looking for a globally unique row ID

> > As you may have noticed, I've put significant effort to focus the > discussion on my actual question: the "global index" (which btw I didn't > know is called this way here - if I new, I'd probably could have google > it instead). This was intentional. I like my schema design very much and >

Re: [GENERAL] looking for a globally unique row ID

> On Sep 16, 2017, at 11:18 AM, Rafal Pietrak <ra...@ztk-rp.eu> wrote: > > Dear robjsarg...@gmail.com, > > W dniu 16.09.2017 o 17:19, Gmail pisze: >> >> >>> On Sep 16, 2017, at 8:23 AM, Rafal Pietrak <ra...@ztk-rp.eu> wrote: >>>

Re: [GENERAL] looking for a globally unique row ID

> On Sep 16, 2017, at 8:23 AM, Rafal Pietrak wrote: > > > > W dniu 16.09.2017 o 15:45, Adam Brusselback pisze: >> Here is the last discussion I saw on >> it: >>

Re: [GENERAL] Text search dictionary vs. the C locale

> On Jul 2, 2017, at 10:06 AM, Tom Lane wrote: > > twoflower writes: >> I am having problems creating an Ispell-based text search dictionary for >> Czech language. > >> Issuing the following command: > >> create text search dictionary czech_ispell

Re: [GENERAL] Text search dictionary vs. the C locale

Sent from my iPad > On Jul 2, 2017, at 10:06 AM, Tom Lane wrote: > > twoflower writes: >> I am having problems creating an Ispell-based text search dictionary for >> Czech language. > >> Issuing the following command: > >> create text search

Re: [GENERAL] Can't restart Postgres

Sent from my iPad > On Feb 14, 2017, at 9:47 PM, Shawn Thomas wrote: > > No it doesn’t matter if run with sudo, postgres or even root. Debian > actually wraps the command and executes some some initial scripts with > different privileges but ends up making sure

Re: [GENERAL] clone_schema function

I had to modify the portion that copies FK constraint: https://gist.github.com/mlibrodo/6f246c483e650dc716eba752a9d3c79a Basically, the issue on my end was that the FK constraints on the cloned(destination) schema seem to reference the source_schema -- Sent via pgsql-general mailing list

Re: [GENERAL] INSERT ON CONFLICT of "wide" table: target lists can have at most 1664 entries

> On Dec 4, 2016, at 9:32 AM, Justin Pryzby wrote: > > Our application INSERTs data from external sources, and infrequently UPDATEs > the previously-inserted data (currently, it first SELECTs to determine whether > to UPDATE). > > I'm implementing unique indices to allow

Re: [GENERAL] Postrgres-XL and Postgres-BDR

Contact any of the professional support organizations and ask for whom they work. Some will, some won't name names. Sent from my iPad > On Dec 3, 2016, at 5:41 PM, Michael Paquier wrote: > >> On Tue, Nov 29, 2016 at 10:25:50AM -0200, Saulo Tadeu wrote: >> I'm would

[GENERAL] Blocksize Config Make Check Failures

I'm attempting to get a little bit more disk performance out of a data warehouse like PG 9.5 RC1 instance I have that is running on ZFS (recordsize=128K). When trying to make PG 9.5RC1 with --blocksize > 8 four of the make check tests are reported as failing. I'm curious as to if this is a

Re: [GENERAL] Database designpattern - product feature

Sent from my iPad On Jun 3, 2015, at 7:50 AM, Adrian Stern adrian.st...@unchained.ch wrote: Hi William, thanks for joining the conversation. 1) We do hope for constraints since a connection to an ERP system is possible in the future. We want to plan ahead. 2) As for the subclass

[GENERAL] Multiple Cluster on same host

I have 2 cluster databases, running on the same host, Ubuntu. My fist database port is set to default but my second database port is set to 5433 in the postgresql.conf file. While everything is ok with local connections, I cannot connect using any of my tools to the second database with port

Re: [GENERAL] Multiple Cluster on same host

Il 19/10/2012 15:24, Chris Ernst ha scritto: On 10/19/2012 07:02 AM, GMAIL wrote: I have 2 cluster databases, running on the same host, Ubuntu. My fist database port is set to default but my second database port is set to 5433 in the postgresql.conf file. While everything is ok with local

Re: [GENERAL] Multiple Cluster on same host

Il 19/10/2012 15:40, Chris Ernst ha scritto: On 10/19/2012 07:24 AM, GMAIL wrote: What happens when you try to connect? Any error message? Log entries? - Chris now i be able to connect, after update pgAdmin, but i receive the following error: ERROR: column datconfig does not exist LINE 1

Re: [GENERAL] Multiple Cluster on same host

Il 19/10/2012 16:05, Chris Ernst ha scritto: On 10/19/2012 07:50 AM, GMAIL wrote: Il 19/10/2012 15:40, Chris Ernst ha scritto: On 10/19/2012 07:24 AM, GMAIL wrote: What happens when you try to connect? Any error message? Log entries? - Chris now i be able to connect, after update pgAdmin

Re: [GENERAL] Multiple Cluster on same host

postgresql 9.1 and pgadmin 1.8.4 And there it is. You'll need pgAdmin = 1.12.x to work with PostgreSQL 9.1. - Chris can be a firewall problem? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Multiple Cluster on same host

Il 19/10/2012 15:40, Chris Ernst ha scritto: On 10/19/2012 07:24 AM, GMAIL wrote: Il 19/10/2012 15:24, Chris Ernst ha scritto: On 10/19/2012 07:02 AM, GMAIL wrote: I have 2 cluster databases, running on the same host, Ubuntu. My fist database port is set to default but my second database port

Re: [GENERAL] Multiple Cluster on same host

Il 19/10/2012 16:11, Shaun Thomas ha scritto: On 10/19/2012 09:06 AM, GMAIL wrote: i use postgresql 9.1 and pgadmin 1.8.4 Yeah, that version of pgAdmin is *way* too old. 1.16 was released fairly recently, and it works great. i try the version 1.16 but it doesn't work. i don't get any

Re: [GENERAL] Multiple Cluster on same host

Il 19/10/2012 16:33, Shaun Thomas ha scritto: If you don't get any error message from the client or the server, are you sure it didn't work? I only ask because 1.8 was so old, I'm surprised it even worked with the version you had before. The catalog has changed a lot since then, and the

Re: [GENERAL] Multiple Cluster on same host

Il 19/10/2012 16:55, Shaun Thomas ha scritto: Yep. You've got a firewall between you and your server. Somewhere. Good luck tracking that down, sir. Everything should clear up when/if that gets resolved. i think that the problem should be the service iptables. what i have to change if i want

Re: [GENERAL] Multiple Cluster on same host

Il 19/10/2012 16:45, Shaun Thomas ha scritto: On 10/19/2012 09:38 AM, GMAIL wrote: but if i connect from another pc, with pgadmin 1.16 or other software, to the host with postgresql i get a connection refused message Ok. That narrows it down slightly. If you check your PG logs for FATAL

[GENERAL] postgresql error while connecting to cluster with pgadmin

i have created two cluster in the same host the first called main with port 5432 the second called remote with port 5433. but when i try to connect with pgadmin3 to the second cluster i get the error authentication failed. if i try to connect to the first cluster i don't have any kind of

[GENERAL] help for this situation

i describe the situation: i have two pc with postgressql server: - a main pc, with ip 192.168.5.1 turned on - a backup pc, with ip 192.168.5.1 turned off i want that the main pc saves the database in local hard drive and on a nas real-time. when the main pc has a failure, i turn on, manually,

[GENERAL] allow servers to access to the same data

it's possible to access the same data from two different servers. the two servers have the same IP and not run simultaneously -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Facing Problem in Autovacuuming Deamon....

Hello, On Tue, 2010-06-22 at 04:50 -0700, Deven wrote: Hi all, I am using Postgresql Database for our system storage and I am running Autovacuuming Deamon on my entire database. But on of the table set in my database never undergoes the Autovacuuming. I always need to do the manual

Re: [GENERAL] autovacuum: 50% iowait for hours

Hello guys, thx for your inputs. I consider you suggestions valid. We have hundreds or thousands of unreachable and unmaintained PG instalations. I'm totally unable to experiment in each of them. Usage profile can range from 100 rows per hour to 1000, 10.000, 50.000... sustained... for several

[GENERAL] list of databases in C ? libpq ?

Hello all, I need to write an application in C to read the list of databases currently in the server. very much like a psql -l... but I need it in C ! I never used C before to access PG. the libpq API seems a bit scary ! Is there anything, shipped with postgresql, other than libpq that would

Re: [GENERAL] Auto VACUUM

On Fri, 2010-03-05 at 10:03 -0500, akp geek wrote: Hi All - I am still having the issue, even after I turned on the auto vaccum. I have quick question. How do I know that auto vacuum process is running. When I restarted my database , I got the message auto vacuum launcher

Re: [GENERAL] Auto VACUUM

On Wed, 2010-03-03 at 12:46 -0500, akp geek wrote: Hi All - I need some help from you. this question is in follow up with my earlier questions. I turned the autovacuum and restarted the db and the settings I have as follows. It seems the autovacuum process has not been turned on.

[GENERAL] CLUSTER on 2 indexes ?

Hello, Considering the CLUSTER operation on a frequently updated table, if I have 2 indexes on the table how do I choose one of them ? or is it possible to have CLUSTER take both into consideration... my table is read from based on two columns: a 'timestamp' integer column (actually a UTC

Re: [GENERAL] db size and VACUUM ANALYZE

On Fri, 2010-02-12 at 18:43 +0100, Marcin Krol wrote: Amitabh Kant wrote: You need to do VACUUM FULL ANALYZE to claim the disk space, but this creates a exclusive lock on the tables. See http://www.postgresql.org/docs/8.3/static/sql-vacuum.html Aha! OK but why did the performance

Re: [GENERAL] Data Directory size increasing abnormally

A strange behaviour is observerd in the physical files with respect to this table. The size of the file is growing abnormally in GBs. Suppose the file name (oid of relation )with respect to the table is 18924 I could find entries of 1 GB files like 18924, 18924.1, 18924.2 ,

Re: [GENERAL] Creating new database

I'dd suggest: pgdumpall --clean dump.sql edit the dump.sql file by hand replacing database name and owners and so... then reload into the new DB with psql -f dump.sql postgres this does all the work except creation of users and databases should give you an exact replica with all data inside

Re: [GENERAL] Creating new database

On Wed, 2009-11-18 at 08:39 -0700, Scott Marlowe wrote: On Wed, Nov 18, 2009 at 8:12 AM, Joao Ferreira gmail joao.miguel.c.ferre...@gmail.com wrote: I'dd suggest: pgdumpall --clean dump.sql I'd think he'd be much better off with pg_dump, not pg_dumpall. yes, agree. sorry. joao

[GENERAL] safelly erasing dirs/files

Hello all, How can I safelly erase (with rm command in Linux) files or dirs concerning a specific database ? assuming I whish to elimiante data belonging to database A but I do not whish to disturb or cause any injury to database B Is there documentation on how to do this or on what exactly am

Re: [GENERAL] safelly erasing dirs/files

was considering rm thx Joao On Sat, 2009-11-14 at 14:35 -0500, Bill Moran wrote: Joao Ferreira gmail joao.miguel.c.ferre...@gmail.com wrote: Hello all, How can I safelly erase (with rm command in Linux) files or dirs concerning a specific database ? What do you mean

Re: [GENERAL] modo texto

On Thu, 2009-05-28 at 16:43 +0100, Grzegorz Jaśkiewicz wrote: On Thu, May 28, 2009 at 4:24 PM, inf200...@ucf.edu.cu wrote: hi, sorry my english I need to copy a data base from windows to linux, how can I save my data base from windows with pg_dump, and where the file is?? and after

Re: [GENERAL] XML - PG ?

hello, as a perl addict I am... I recommend checking this out: http://search.cpan.org/~cmungall/DBIx-DBStag/DBIx/DBStag/Cookbook.pm it's pretty flexible and allows you to specify to some extent just how the database structure is infered from the XML... check it out Joao On Wed, 2009-05-06

Re: [GENERAL] XML - PG ?

On Wed, 2009-05-06 at 16:53 +0100, Joao Ferreira gmail wrote: hello, as a perl addict I am... I recommend checking this out: http://search.cpan.org/~cmungall/DBIx-DBStag/DBIx/DBStag/Cookbook.pm it's pretty flexible and allows you to specify to some extent just how the database structure

Re: [GENERAL] Selling an 8.1 to 8.3 upgrade

pg 8.1.4 has a very ugly bug which prevents VACUUM and AUTOVACUUM from performing well I certain situations the AUTOVACUUM will start failing and any VACUUM operations will fail too. solution I found was to periodically REINDEX my tables and INDEXES. the major effect of this bug is Pg

Re: [GENERAL] From 8.1 to 8.3

On Wed, 2009-04-22 at 22:12 +0530, S Arvind wrote: Our company wants to move from 8,1 to 8.3 latest. In irc they told me to check realse notes for issues while upgrading. But there are lots of release notesss. Can anyone tell some most noticable change or place-of-error while upgrading? one I

Re: [GENERAL] psql 8.1.9 autovacuum safe?

On Sun, 2009-04-12 at 09:27 -0700, Irene Barg wrote: Hi, We are running postgresql-8.1.9 and plan to upgrade to 8.2 or even 8.3 but can't just yet. I need to run analyze periodically (like hourly), but before I write a script to loop through the tables in each schema and run analyze, I

Re: [GENERAL] possible pg_dump bug

On Wed, 2009-01-28 at 09:09 -0800, David Miller wrote: Pg Dump does not include schema name on insert statement generated from pg_dump with a -d option when exporting data for a particular table using the -t schema.table in version 8.3. I believe this same bug exists in 8.4 but have not

[GENERAL] merge 2 dumps

hello all, I have 2 dumps of the same Pg database in diferent instants. I'dd like to merge the two dumps into one single dump in order to restore all data at one time. Is this possible ? are there any helper tools to aid in dealing with text dump files ? thanks Joao -- Sent via

Re: [GENERAL] merge 2 dumps

On Tue, 2008-11-11 at 11:16 +, Richard Huxton wrote: Joao Ferreira gmail wrote: hello all, I have 2 dumps of the same Pg database in diferent instants. I'dd like to merge the two dumps into one single dump in order to restore all data at one time. Is there any overlap

Re: [GENERAL] Upgrading Postgres question

On Wed, 2008-11-05 at 15:08 -0600, Tony Fernandez wrote: Hello all, I am in the process of updating my DB on Postgres 8.1.11 to 8.3.4. I also use Slony 1.2.14 for replication. Is there a safe path on how to accomplish this, please advice on what steps I will need to consider.

[GENERAL] time interval format srting

Hello, I've been searching the docs on a simple way to convert a time _duration_ in seconds to the format dd:hh:mm:ss, but I can't find it. 90061 -- 1d 1h 1m 1s (90061=24*3600+3600+60+1) any ideas ? I've been using to_char and to_timestamp to format dates/timestamps... but this is diferent...

[GENERAL] speed up restore from dump

Hello all, I've been tring to speed up the restore operation of my database without success. I have a 200MB dump file obtained with 'pg_dumpall --clean --oids'. After restore is produces a database with one single table (1.000.000) rows. I have also some indexes on that table. that's it. It

Re: [GENERAL] speed up restore from dump

On Thu, 2008-10-30 at 11:39 -0700, Alan Hodgson wrote: On Thursday 30 October 2008, Joao Ferreira gmail [EMAIL PROTECTED] wrote: What other cfg paramenters shoud I touch ? work_mem set to most of your free memory might help. I've raised work_mem to 128MB. still get the same 20 minutes

Re: [GENERAL] run postgres 8.3

Hello Eduardo On Tue, 2008-10-14 at 15:40 -0500, Eduardo Arévalo wrote: I installed the 8.3 postgres the amount of giving the command: bash-3.2$ /usr/local/postgres_8.3/bin/initdb -D /base/data that command only initializes the underlying filesystem database files, directories and

[GENERAL] databases list to file

Hello all, I need to print to a file a simple list of all the databases on my postgresql. I need to do this from a shell script to be executed without human intervention I guess something like: su postgres -c 'psql ...whatever /tmp/my_databases.txt' but I don't know exactly to what

[GENERAL] when COPY violates Primary Keys

Hello all, I have a ascii dump file based on the COPY operation. lets say I restore this dump into a live database with applications doing INSERTs and UPDATEs onto it. in case the COPY of a register causes a primary key (or UNIQUE, or FK) violation does the psql restore command try to continue

Re: [GENERAL] match an IP address

thank you depesz it seems a pretty good fix for my problem. Actually yestreday I came up with something similar but your's is better. cheers joao On Tue, 2008-09-23 at 09:26 +0200, hubert depesz lubaczewski wrote: On Mon, Sep 22, 2008 at 05:59:25PM +0100, Joao Ferreira gmail wrote: I'm

[GENERAL] match an IP address

hello all, I'm unable to build a LIKE or SIMILAR TO expression for matching and ip address 192.168.90.3 10.3.2.1 any help please... thanks joao -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] match an IP address

well... my IP addresses are stored in a TEXT type field. that field can actually contain usernames like 'joao' or 'scott' and it can contain IP addresses :( joao On Mon, 2008-09-22 at 11:13 -0600, Scott Marlowe wrote: On Mon, Sep 22, 2008 at 10:59 AM, Joao Ferreira gmail [EMAIL

Re: [GENERAL] about partitioning

case. any hints. thx j On Sat, 2008-09-13 at 16:48 -0400, Robert Treat wrote: On Thursday 11 September 2008 07:47:00 Joao Ferreira gmail wrote: Hello all, my application is coming to a point on which 'partitioning' seems to be the solution for many problems: - query speed up

[GENERAL] about partitioning

Hello all, my application is coming to a point on which 'partitioning' seems to be the solution for many problems: - query speed up - data elimination speed up I'dd like to get the feeling of it by talking to people who use partitioning, in general.. - good, bad, - hard to manage, easy to

Re: [GENERAL] Changes for version 8.4

Is there a date for the release of 8.4 ? joao On Thu, 2008-09-04 at 10:09 -0400, Alvaro Herrera wrote: paul tilles wrote: Where can I find a list of changes for Version 8.4 of postgres? It's not officially written anywhere. As a starting point you can look here:

[GENERAL] autovacuum settings

Hello all, in which system tables can I find the effective run-time values of the autovacuum configuration parameters... naptime, thresholds, scale factors, etc thx joao -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

[GENERAL] upgrading from 8.1.4 to 8.3.3

Hello all, I'm getting this error after installing pg-8.3.3 on a test system which had 8.1.4 shell su postgres -c /usr/bin/postmaster -D /var/pgsql/data FATAL: database files are incompatible with server DETAIL: The data directory was initialized by PostgreSQL version 8.1, which is not

Re: [GENERAL] Vaccuum best practice: cronjob or autovaccuum?

On Thu, 2008-08-28 at 19:53 +0800, Phoenix Kiula wrote: On our database of about 5GB we vaccuum all of our 12 tables (only one is huge, all others have about 100,000 rows or so) every hour or so. if you refer to manual VACUUM or VACUUM FULL every hour is probably too much. You should aim your

Re: [GENERAL] Vaccuum best practice: cronjob or autovaccuum?

, Bill Moran wrote: In response to Joao Ferreira gmail [EMAIL PROTECTED]: On Thu, 2008-08-28 at 19:53 +0800, Phoenix Kiula wrote: On our database of about 5GB we vaccuum all of our 12 tables (only one is huge, all others have about 100,000 rows or so) every hour or so. if you refer

Re: [GENERAL] Restoring a database from a file system snapshot

Any suggestions? Is my procedure correct? Would I need to also copy the transaction logs or something like that? the 'by the book' procedure for this operation is to use pg_dumpall . dump_file.sql and later psql -f dump_file.sql postgres pg_dumpall gives you a transaction

[GENERAL] negative values for vacuum threshold check !!!

Hello all While debugging my autovacuum I increased the level of logging to debug3 and got this: # cat /var/pgsql/data/logfile | grep vac | egrep mydb|mytable LOG: autovacuum: processing database mydb DEBUG: mytbl: vac: 10409 (threshold 20), anl: -183366 (threshold 5) LOG:

[GENERAL] failed to re-find parent key in ...

Hello all, a few days ago I bumped into this: - # vacuumdb -f -z -a vacuumdb: vacuuming database postgres VACUUM vacuumdb: vacuuming database rtdata vacuumdb: vacuuming of database rtdata failed: ERROR: failed to re-find parent key in

Re: [GENERAL] automatic REINDEX-ing

Because VACUUM FULL needs to move stuff around in the table which means it need to mess around with the indexes (adding new entries). Ordinary VACUUM only needs to delete stuff so doesn't cause anywhere near as many problems. so in the event that I really end up running VACUUM FULL once

Re: [GENERAL] big database with very small dump !?

| 3673 kB edgereporting | 3617 kB template1 | 3617 kB template0 | 3537 kB (7 rows) postgres=# V. Joao Ferreira gmail wrote: Hello all, I'm finding it very strange that my pg takes 9Giga on disk but pg_dumpall produces a 250Mega dump

Re: [GENERAL] big database with very small dump !?

) timeslots_timestamp_index btree (timestamp) timeslots_var_index btree (var) egbert=# On Mon, 2008-08-11 at 12:45 -0400, Greg Smith wrote: On Mon, 11 Aug 2008, Joao Ferreira gmail wrote: I'm finding it very strange that my pg takes 9Giga

Re: [GENERAL] big database with very small dump !?

On Mon, 2008-08-11 at 12:45 -0400, Greg Smith wrote: On Mon, 11 Aug 2008, Joao Ferreira gmail wrote: I'm finding it very strange that my pg takes 9Giga on disk but pg_dumpall produces a 250Mega dump. 'VACUUM FULL' was executed yesterday. If you've been running VACUUM FULL, it's

Re: [GENERAL] big database with very small dump !?

On Mon, 2008-08-11 at 10:58 -0600, Scott Marlowe wrote: It's likely you've got index bloat. If you reload a pg_dump of the database in question into another server how much space does that take up? right. just loaded the dump into a clean database and everything came down about 10 times...

[GENERAL] automatic REINDEX-ing

Hello all [[[ while dealing with a disk size problem I realised my REINDEX cron script was not really being called every week :( so... ]]] I executed REINDEX by hand and the disk ocupation imediatelly dropped 6 Giga...!!! is there a way to configure postgres to automatically execute the

Re: [GENERAL] automatic REINDEX-ing

On Tue, 2008-08-12 at 11:53 -0400, Tom Lane wrote: TW, more aggressive routine vacuuming does NOT mean use vacuum full. Vacuum full tends to make index bloat worse, not better. regards, tom lane Ok. so what does it mean ? I'm a bit lost here. I'm currently

Re: [GENERAL] big database with very small dump !? SOLVED

Ferreira gmail wrote: On Mon, 2008-08-11 at 10:58 -0600, Scott Marlowe wrote: If I try cluster, I'm guessing I'll choose the big index and forget about the smaller ones... is this right ? CLUSTER will sort out all the indexes, even though you're just clustering on on. -- Sent

[GENERAL] diagnostic, admin, maintenance tool

Hello all, could you please recommend tools to make diagnostic, admin and maintenance work easier... I imagine there are tools (maybe graphical, or browser based) that allow me to connect to postgres and receive diagnostic data and pointers/recommendations on how to solve specific problems or

[GENERAL] big database with very small dump !?

Hello all, I'm finding it very strange that my pg takes 9Giga on disk but pg_dumpall produces a 250Mega dump. 'VACUUM FULL' was executed yesterday. Is this normal ? Should I be worried ? details bellow:

[GENERAL] running two instances of pg

Hello all, we are using PostgreSQL in a situation where I think we could try and run two separate instances: - 1 application can grow up to 10 Giga data; needs 'frequent' vaccuming and re-indexing (lots of insert, updates and deletes, per minute): we use it for 'near-real-time' applications logs

[GENERAL] INDEX on a composite type

Hi all. When trying to create an index on a composite type, I need to enclose the columns in paranthesis. Is this normal? I don't think so as there's no mention in the friendly manual. An example: create type atype as ( atext text, anint int ); create table atable ( info text, compo

Re: [GENERAL] INDEX on a composite type

Il Wednesday 19 December 2007 22:29:25 Colin Wetherbee ha scritto: GMail wrote: When trying to create an index on a composite type, I need to enclose the columns in paranthesis. Is this normal? I don't think so as there's no mention in the friendly manual. I think your problem is similar