I have a new 1 TB drive coming in tomorrow. What is the best way to divide this space for a development workstation? The biggest problem I think I'm going to have is that some partitions (probably /usr) will become to small after a bit of use. Other partitions are probably to huge. The swap drive for example is currently 2GB (2x 1GB RAM...
is there a solution for batch insert via hibernate in partitioned postgresql table? currently i'm getting an error like this... 57286 [pool-1-thread-18] ERROR org.hibernate.jdbc.AbstractBatcher - Exception executing batch: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0...
I'm currently facing a hardware HD problem. Once of my HDs has semi-died. It works, kind of, data is being read, but every now and then it decides to not respond for a while. Windows hangs for a few seconds, and sometimes I get an event in my event log saying that the device didn't respond fast enough, or something to that effect. Now ...
My primary partition has become full on Debian and I don't appear to be able to resize it while the system is running... How can I make space on this partition? Filesystem Size Used Avail Use% Mounted on /dev/sda1 259M 259M 0 100% / tmpfs 443M 0 443M 0% /lib/init/rw udev ...
How are non-deterministic functions used in SQL partitioning functions and are they useful? ...
Hi [Linux Newbie]- I'm going to buy a server to host an Oracle database. The server will be running Red Hat Enterprise Linux 5. The server will have 6 hard drives. I know there is a limit of 4 primary partitions in Linux. Here is my question: Is the 4 partition limit per physical hard drive (so I could have 6 disks x 4 primary part...
Accessing a raw disk partition in Windows Vista requires kernel mode control, as opposed to for instance WinXP where you can access it from user mode. However, I've heard that when it comes to USB flash memory, a partition can still be accessed from user mode even on Windows Vista. Is this true? Regards /Robert ...
Someone asked me a question via e-mail about integer partitions the other day (as I had released a Perl module, Integer::Partition, to generate them), that I was unable to answer. Background: here are all the integer partitions of 7 (the sum of each row equals 7). 7 6 1 5 2 5 1 1 4 3 4 2 1 4 1 1 1 3 3 1 3 2 2 3 2 1 1 3 1 1 1 1 2 2 2 1 ...
Hi, my partition /tmp is full... and its empty at the same time. So the partition is full. Check the directory: # du -sh /tmp 28K /tmp What? It is empty... And it is really empty... just two empty directories are located in /tmp Checking partition details: # df -h Filesystem Size Used Avail Use% Mounted on /dev/cciss/c0...
When trying to partition a hard drive on ESX server I frequently run into the following problem: $ fdisk /dev/sdd Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel Building a new DOS disklabel. Changes will remain in memory only, until you decide to write them. After that, of course, the previous co...
SpousesTable SpouseID SpousePreviousAddressesTable PreviousAddressID, SpouseID, FromDate, AddressTypeID What I have now is updating the most recent for the whole table and assigning the most recent regardless of SpouseID the AddressTypeID = 1 I want to assign the most recent SpousePreviousAddress.AddressTypeID = 1 for each unique Spou...
Recently my company forced a roll out of SafeBoot. The problem is that I was using Ubuntu under Wubi. Since the whole drive is encrypted now, I can't boot into Ubuntu. I was hoping to create a new partition for Ubuntu so I could still use it. I know there are partition tools available, but I've never used one on an encrypted disk. Are pr...
I have two unix partitions under debian which I would like to merge (disk space problems :/). What would be the easiest way to do it? I think it would be best to tar or copy files from one partition to the other, delete one and resize the other. I will use parted to resize but how should I copy the files? There are links, permissions and...
So I took some files with me on my external HDD while going on vacation. Through a series of events, I ended up storing the data in a NTFS formatted partition defined in a GUID Partition Table. The only computer I have is a Windows XP home box, which does not have native support for reading GPT's. So far everything I have read online ...
Hello folks, I have some questions about partitioning and strategy, how and when to use it. As I understood from Partitioned Tables and Indexes in SQL Server 2005, partitioning is not used only for manageability but also to improve performance on very large database tables (VLDB). We have a table with millions of records. This table st...
In Oracle 10g I'm creating a range partitioned table. Each partition will be a year. My question is what do you use for the name of the MaxValue partition? I was planning to call my partitions P2001, P2002, P2003 ... P2009. Suggestions welcome, I've considered P9999, PCurrent, PThisYear, PFuture, PEmpty, PMaxValue, and PCreateAnother...
Hi, My windows xp (C drive) partition is 27 GB. Now it shows free space is only 2.3 GB. But when I calculate all the space using any software or manually (by adding all the folder sizes including hidden files) I get ~13.xx GB full. That means another 13.xx GB should be free. Also while using ubuntu, I see 13.4 GB free in "Disk Usage An...
Hi folks, in a previous question i asked, the suggested answer was for me to partition my field onto another Filegroup, keeping the field in the same table. I'm not sure how to do this. I've tried to google for things like partition table, partition view, etc. Could anyone provide me with some links or some sample sql code? DB Server ...
I have a table that I would like to partition, but I don't know how to deal with the uniqueness constraints. Is it possible to create a unique constraint across multiple child tables? ...
I have a partitioned fact table on a SQL Server 2005 (Ent, Ed., 32 bit, SP2) that I am constructing a partition for (the fact table is a snapshot type). The process builds the data in a separate table, applies appropriate indexes and then switches the partition into the table. This has worked in the past The table structures are ident...